DB Error

[LEC]

Hello,

I know, that this problem was monitored here, on forum, but there was'nt given any solution how to fix that (or i'm blind   )

I get this error after clean installation:

 

Code: [Select]

DB Error: Bad SQL Query: SELECT u.*, l.* FROM 4images_users u, 4images_lightboxes l WHERE u.user_id = AND l.user_id = u.user_id
You have an error in your SQL syntax near 'AND l.user_id = u.user_id' at line 3

DB Error: Bad SQL Query: SELECT * FROM 4images_users WHERE user_id =
You have an error in your SQL syntax near '' at line 3


When i try to ignore it & login, a get another:

Code: [Select]

DB Error: Bad SQL Query: SELECT u.*, l.* FROM 4images_users u, 4images_lightboxes l WHERE u.user_id = AND l.user_id = u.user_id
You have an error in your SQL syntax near 'AND l.user_id = u.user_id' at line 3

DB Error: Bad SQL Query: SELECT * FROM 4images_users WHERE user_id =
You have an error in your SQL syntax near '' at line 3

Warning: Cannot add header information - headers already sent by (output started at /home/services/host.sk.icpnet.pl/html/galeria/includes/db_mysql.php:185) in /home/services/host.sk.icpnet.pl/html/galeria/includes/sessions.php on line 52

Warning: Cannot add header information - headers already sent by (output started at /home/services/host.sk.icpnet.pl/html/galeria/includes/db_mysql.php:185) in /home/services/host.sk.icpnet.pl/html/galeria/includes/sessions.php on line 52

Warning: Cannot add header information - headers already sent by (output started at /home/services/host.sk.icpnet.pl/html/galeria/includes/db_mysql.php:185) in /home/services/host.sk.icpnet.pl/html/galeria/login.php on line 60


SQL is on the same machine (localhost) - HTTP server (running Apache/1.3.24 (Unix)  (PLD/Linux) mod_xslt/1.0 mod_ssl/2.8.7 OpenSSL/0.9.6b mod_perl/1.26 PHP/4.1.2; MySQL 3.23.49


Can U help me ? plz....

btw: on my local-testing serwer (FoxServ on Windows) everything works fine...  

[Jan]

Hi!

Hmmm..strange, never heard it before. If have really no idea. It seems that the user_id is missing in the session class.
Did you have any other error messages?

Greets Jan[/list]

[LEC]

Hi,


Well, i've checked database using PhpMyAdmin:

- there's 2 users after installation: me as admin, and Guest, there's Iser ID 9 for admin user and -1 for Guest. So, for me it seems to be right....


Other errors? Installation went smooth, first error was afer loading login.php... You can Check it on your own , here: http://host.sk.icpnet.pl/galeria/

If You wanna have some fun trying to fix it, I can send you login & pass either....

Geeeee, I was wonderring.... maybe it's something with the rights ?

[Jan]

Yes, you can send me your server login details.
jan@dotsunited.de

Greets Jan

[LEC]

ok, thx a lot already sended...

[Jan]

Ok, i fixed it. It seems there are some problems with the ips. Your server changed the ips in formats like :::fff:f127.0.0.1. It should work now.

Greets Jan

[LEC]

that's correct, but it doesn't crash any other scripts (phpbb2, gallery, phparena) so I thought this time it wont be the crash-reason too...

Anyway thx a lot... You changed something in in php or in the database? I would be usefull to know for the future reinstalations...

You will be always welcome on the gallery - pretty much thanx again. Maybe as a thank You want polish laguage pack ? (made by myself)

[Jan]

I only changed "includes/sessions.php". In future releases i will integrate the changes i made in your script.

You can offer a polish language pack if you want but i don't take up any further "official" language packs.

Greets Jan

[LEC]

ok, I understand. See YA!