Author Topic: DB Error: Bad SQL Query: << ERROR/FEHLER with/mit mySQL 5  (Read 25921 times)

0 Members and 1 Guest are viewing this topic.

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
DB Error: Bad SQL Query: << ERROR/FEHLER with/mit mySQL 5
« on: September 18, 2007, 07:29:17 PM »
Deutsch:
Code: [Select]
Unbekanntes Tabellenfeld 'i.user_id' in on clauseTip: 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: [Select]
Unknown column 'i.user_id' in 'on clause'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
« Last Edit: October 23, 2008, 03:15:22 PM by V@no »
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline dawolf

  • Pre-Newbie
  • Posts: 2
    • View Profile
    • http://www.screenagers.at/
Re: DB Error: Bad SQL Query: << ERROR/FEHLER with/mit mySQL 5
« Reply #1 on: November 18, 2008, 12:29:12 PM »
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: [Select]
perl -pi '-es/(FROM\s+)("\.[A-Z_]+\."\s+[a-z]+,\s*"\.[A-Z_]+\."\s+[a-z]+)/$1($2)/g' *.php
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!