wah, failed to update to mysql5 ?

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
  
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   HostRocket Webhosting for SMF
  
   Site Showcase

Advanced search

[trifox]

hi there, when switching my db to mysql 5, due to a bigger database, i receive the mysql
join error from the gallery:

"collumn gallery_pic.ID_CAT" does not exists .... 

damn it .... do i have to manually edit all the queries to fix this ?!

because my update has expired....


arrrgh.............. 


what can i do ?!?


heeelp!

[SMFHacks]

Haven't seen that before. I use MySQL 5 for all my sites.
What gallery version? And what SMF version?

[trifox]

hi

Gallery:
Your Version: 3.0.3 Latest Version: 3.0.25 Your gallery version is not up to date!

Forum:
Powered by SMF 1.1.14 | SMF © 2006-2011, Simple Machines LLC

i have checked the sql queries in the scripts, and they all seem fine ( joins via embraced multi-tables)
so, then i do not understand what causes the error, because the error occurs on any page
on the forum, not only the gallery .... is there a way to temporarily disable the plugin for the forum ?

[SMFHacks]

You can turn off view permissions under permissions for the gallery.
What line number was the error?

[trifox]

it does not include a line number, that is the problem ... it just says
"collumn gallery_pic.ID_CAT" does not exists ....


turning off view permissions ? i wonder how come that if i visit the board index, the error occurs as well...

[trifox]

this is a discussion about the problem,
http://forums.oscommerce.com/topic/208286-1054-unknown-column-xxx-in-on-clause/

[SMFHacks]

The gallery does not touch the board index at all unless you have an addon. if that is the case remove the addon but that error message isn't tell me much and looks like it is not correct ""collumn gallery_pic.ID_CAT"  column is not spelled right. and I don't know the file name or the line number.

[trifox]

yes, i typed it by hand
what do you mean by addon !?
i do not use any images on the index page, i will try another move this weekend, cant explain the error as well, cause everything looks fine.... in the db, and in the scripts...

[SMFHacks]

An addon for gallery pro such as show images on board index etc

[trifox]

no i do not use any of those, the only thing i did was changing the settings.php file, and when it is using the database
the error occurs, is there some kind of debug mode to output all mysql queries ? perhaps i should hack a little output into smf ....

i am wondering as well why it is using the gallery for the index page, didnt had time to make any further tests, hope to grab some time on upcoming weekend
 

[SMFHacks]

There is a forums error log and a setting you can add to your settings.php file but dont' remember it offhand.

[trifox]

hi there, just to keep you informed:

the problem was with an own skript i added to the gallery, where i use banners uploaded to the gallery to show on main page, in this sql query i didnt confer to the mysql5 braces syntax that made the query stop ....

so, it had something to do with the gallery, but it wasnt in the core ... i was just mislead by interpreting the database tables...

Help Support the SMFHacks.com mod making.