DB Error: unknown error
CREATE TABLE phpbt_auth_user ( user_id int(10) unsigned NOT NULL default '0', login char(40) NOT NULL default '', first_name char(40) NOT NULL default '', last_name char(40) NOT NULL default '', email char(60) NOT NULL default '', password char(40) NOT NULL default '', active tinyint(3) unsigned NOT NULL default '1', bug_list_fields text NOT NULL default '', created_by int(10) unsigned NOT NULL default '0', created_date bigint(20) unsigned NOT NULL default '0', last_modified_by int(10) unsigned NOT NULL default '0', last_modified_date bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (user_id), UNIQUE KEY login (login)) TYPE=MyISAM; [nativecode=1101 ** BLOB/TEXT column 'bug_list_fields' can't have a default value]
DB Error: no such table
INSERT INTO phpbt_auth_user (user_id, login, first_name, last_name, email, password, active) values (0, 'Anonymous User', 'Anonymous', 'User', '', '', 0); [nativecode=1146 ** Table 'phpbt.phpbt_auth_user' doesn't exist]
DB Error: no such table
INSERT INTO phpbt_auth_user (user_id, login, first_name, last_name, email, password) values (1, 'tince@viecorefsd.com', 'System', 'Admin', 'tince@viecorefsd.com', '3bd691894adfa154593c65bfa0e2eca7'); [nativecode=1146 ** Table 'phpbt.phpbt_auth_user' doesn't exist]
DB Error: no such table
INSERT INTO phpbt_user_pref (user_id) SELECT USER_ID FROM phpbt_auth_user; [nativecode=1146 ** Table 'phpbt.phpbt_auth_user' doesn't exist]
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Also, the install script never created the config.php file for me.
So I created my own manually and am FINALLY using PHP Bug Tracker, but now at the top of the index page, I get these 2 error messages -
Notice: Undefined variable: fastlinks1 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\phpbt\index.php on line 111
Notice: Undefined variable: fastlinks2 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\phpbt\index.php on line 112
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Well, first off the SQL is wrong. I found the schema files, and a couple things.
MySQL does not allow default values for BLOB/TEXT. So, the SQL INSERTS should just set the value for bug_list_fields to ''.
Also, why TYPE=MyISAM? MyISAM is the default, so if you want that to be the engine, don't need to specify it. Also, the correct syntax is ENGINE=, not TYPE=.
Even after fixing the schema script, so the install would finally work, I still get errors at the top of the pages. Is this release broke? Should I try an older release? Is this software still in BETA? What's the deal?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
DB Error: unknown error
CREATE TABLE phpbt_auth_user ( user_id int(10) unsigned NOT NULL default '0', login char(40) NOT NULL default '', first_name char(40) NOT NULL default '', last_name char(40) NOT NULL default '', email char(60) NOT NULL default '', password char(40) NOT NULL default '', active tinyint(3) unsigned NOT NULL default '1', bug_list_fields text NOT NULL default '', created_by int(10) unsigned NOT NULL default '0', created_date bigint(20) unsigned NOT NULL default '0', last_modified_by int(10) unsigned NOT NULL default '0', last_modified_date bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (user_id), UNIQUE KEY login (login)) TYPE=MyISAM; [nativecode=1101 ** BLOB/TEXT column 'bug_list_fields' can't have a default value]
DB Error: no such table
INSERT INTO phpbt_auth_user (user_id, login, first_name, last_name, email, password, active) values (0, 'Anonymous User', 'Anonymous', 'User', '', '', 0); [nativecode=1146 ** Table 'phpbt.phpbt_auth_user' doesn't exist]
DB Error: no such table
INSERT INTO phpbt_auth_user (user_id, login, first_name, last_name, email, password) values (1, 'tince@viecorefsd.com', 'System', 'Admin', 'tince@viecorefsd.com', '3bd691894adfa154593c65bfa0e2eca7'); [nativecode=1146 ** Table 'phpbt.phpbt_auth_user' doesn't exist]
DB Error: no such table
INSERT INTO phpbt_user_pref (user_id) SELECT USER_ID FROM phpbt_auth_user; [nativecode=1146 ** Table 'phpbt.phpbt_auth_user' doesn't exist]
Also, the install script never created the config.php file for me.
So I created my own manually and am FINALLY using PHP Bug Tracker, but now at the top of the index page, I get these 2 error messages -
Notice: Undefined variable: fastlinks1 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\phpbt\index.php on line 111
Notice: Undefined variable: fastlinks2 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\phpbt\index.php on line 112
Add a project, and those errors will go away. It's a bug that should be fixed.
Well, first off the SQL is wrong. I found the schema files, and a couple things.
MySQL does not allow default values for BLOB/TEXT. So, the SQL INSERTS should just set the value for bug_list_fields to ''.
Also, why TYPE=MyISAM? MyISAM is the default, so if you want that to be the engine, don't need to specify it. Also, the correct syntax is ENGINE=, not TYPE=.
Even after fixing the schema script, so the install would finally work, I still get errors at the top of the pages. Is this release broke? Should I try an older release? Is this software still in BETA? What's the deal?
This software has been stable several years. Can you supply a patch? Could it be a version difference in mysql? Did you use mysql or mysqli?
Check the mysql and mysqli schema files, both. Though the older one can probably be deleted at this point -- nobody will be using such an old MySQL.