Author Topic: Error occured when  (Read 3185 times)

0 Members and 1 Guest are viewing this topic.

Offline McTomy

  • Pre-Newbie
  • Posts: 6
    • View Profile
Error occured when
« on: May 02, 2003, 06:01:33 AM »
During the integration works, I open the install.php page,it reads:
DB Error: Bad SQL Query: SELECT setting_name, setting_value FROM 4images_settings
Table '51doggiehttpd.4images_settings' doesn't exist

the tables of 4images and vBulletin are on the same database[51doggiehttpd].

Files that changed:

includes/constants.php

define('SESSIONS_TABLE', $table_prefix.'sessions');
to
define('SESSIONS_TABLE', 'session');

define('USERS_TABLE', $table_prefix.'users');
to
define('USERS_TABLE', 'user');

       define('GUEST', -1);
       define('USER_AWAITING', 1);
       define('USER', 2);
       define('ADMIN', 9);
to
       define('GUEST', 0);
       define('USER_AWAITING', 3);
       define('USER', 2);
       define('ADMIN', 6);

define('ADMIN_SAFE_LOGIN', 1);
to
define('ADMIN_SAFE_LOGIN', 0);

Offline gurl

  • Newbie
  • *
  • Posts: 32
    • View Profile
Error occured when
« Reply #1 on: May 09, 2003, 10:15:30 PM »
i think u didn't create a database for 4images in ur PHP server. Cause i used to got the same problem that 4images_settings doens't exist.

go to data/database/default/mysql.sql (it should be rite). read it then go to ur phpMyAdmin & create the tables.