4images Help / Hilfe > FAQ, Tips

DB Error: Bad SQL Query: << ERROR/FEHLER with/mit mySQL 5

(1/1)

Nicky:
Deutsch:

--- Code: ---Unbekanntes Tabellenfeld 'i.user_id' in on clause
--- End code ---
Tip: dein provider hat auf mySQL 5 umgestellt: folgende dateien editieren damit alles wieder reibungslos funktioniert
http://www.4homepages.de/forum/index.php?topic=22668.0


English:

--- Code: ---Unknown column 'i.user_id' in 'on clause'
--- End code ---
Tip: your hoster changed to mySQL 5: following files you should edit to get it work again.
http://www.4homepages.de/forum/index.php?topic=22668.0

dawolf:
Based on Vano's post I corrected this problem by running a perl command from the shell in the 4images root dir, the \admin dir and the \includes dir:


--- Code: ---perl -pi '-es/(FROM\s+)("\.[A-Z_]+\."\s+[a-z]+,\s*"\.[A-Z_]+\."\s+[a-z]+)/$1($2)/g' *.php
--- End code ---

This might be useful for people without access to Ultraedit. Feel free to update Vanos post with this information, i am not allowed to reply there.

Remember to BACK UP everything before you try this!

Navigation

[0] Message Index