4images Forum & Community
Welcome, Guest. Please login or register.
Did you miss your activation email?
October 23, 2018, 04:37:30 AM

Login with username, password and session length
Search:     Advanced search
Check the new Tutorial subforum with helpfull guides and tutorials for modifications and tweaks.
Togle to toolbar
Translate this page with =>
Translate this page >
* Home Help Search Login Register
+  4images Forum & Community
|-+  4images Help / Hilfe
| |-+  FAQ, Tips
| | |-+  DB Error: Bad SQL Query: << ERROR/FEHLER with/mit mySQL 5
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Print
Author Topic: DB Error: Bad SQL Query: << ERROR/FEHLER with/mit mySQL 5  (Read 19500 times)
4images Guru
Offline Offline

Posts: 3195

Thank You
-Given: 26
-Receive: 57

View Profile
« on: September 18, 2007, 07:29:17 PM »

Unbekanntes Tabellenfeld 'i.user_id' in on clause
Tip: dein provider hat auf mySQL 5 umgestellt: folgende dateien editieren damit alles wieder reibungslos funktioniert

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.
« Last Edit: October 23, 2008, 03:15:22 PM by V@no » Logged

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 Offline

Posts: 2

Thank You
-Given: 0
-Receive: 0

View Profile WWW
« 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:

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!
Pages: [1] Print 
« previous next »
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.084 seconds with 19 queries.
Post your comments here