4image Галерея

[Alex]

Установил галерию. Проинтегрировал в форум.

 

Начали сыпаться ошибки.

DB Error: Bad SQL Query: DELETE FROM 4images_sessions WHERE ip_address=''

Unknown column 'ip_address' in 'where clause'

 

DB Error: Bad SQL Query: SELECT id FROM 4images_sessions

Unknown column 'id' in 'field list'

 

DB Error: Bad SQL Query: SELECT u.*, l.* FROM 4images_users u, 4images_lightboxes l WHERE u.id = 1 AND l.user_id = u.id

Unknown column 'u.id' in 'where clause'

 

DB Error: Bad SQL Query: SELECT * FROM 4images_users WHERE id = 1

Unknown column 'id' in 'where clause'

 

DB Error: Bad SQL Query: SELECT id FROM 4images_sessions WHERE id = 'b099efbdcc928a5d46894f960d627f90'

Unknown column 'id' in 'field list'

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site18/fst/var/www/html/gallery/includes/ db_mysql.php on line 164

 

DB Error: Bad SQL Query: INSERT INTO 4images_sessions (id, member_name, member_id, ip_address, browser, running_time, location, login_type, member_group) VALUES ('b099efbdcc928a5d46894f960d627f90', '', '0', '', '', '', ',,', '', '')

Unknown column 'id' in 'field list'

 

Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site18/fst/var/www/html/gallery/includes/ db_mysql.php:188) in /home/virtual/site18/fst/var/www/html/gallery/includes/sessions.php on line 113

 

Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site18/fst/var/www/html/gallery/includes/ db_mysql.php:188) in /home/virtual/site18/fst/var/www/html/gallery/includes/sessions.php on line 113

 

DB Error: Bad SQL Query: SELECT s.member_id, s.running_time, s.ip_address, u.id, u.mgroup, u.name FROM 4images_sessions s LEFT JOIN 4images_users u ON (u.id = s.member_id) WHERE s.running_time >= 1053954241 ORDER BY u.id ASC, s.ip_address ASC

Unknown column 's.member_id' in 'field list'

 

DB Error: Bad SQL Query: SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY RAND()

Unknown column 'u.name' in 'field list'

 

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.id = i.user_id) WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.cat_id IN (0, 1, 2) ORDER BY i.image_date DESC LIMIT 3

Unknown column 'u.name' in 'field list'

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site18/fst/var/www/html/gallery/includes/ db_mysql.php on line 116

 

Кто нибудь с этим сталкивался.

Что может быть?

[Total]

база полетела. Он не находит нужных таблиц.

[Alex]

Total

 

Да вроде база на месте. Не полетела.

[Total]

Это случилось спонтанно или же после какой-то модификации?

[Alex]

Нашел.

Не поменял файл constants.php

Сейчас все ок.