Maybe I'm missing something, but let's go back a bit, starting with a fresh install - using the new 1.1 - executing setup.cgi gives me this:
Connecting to the database.
Please switch to the new connect method documenteded in DBI 0.84:
$dbh = DBI->connect($dsn).
We now emulate the call
$drh->connect('Links:localhost'),
but this exception will go away soon.
at /usr/local/lib/perl5/site_perl/DBI.pm line 352
Connecting ... ok!
(I'm not exactly sure what this error message means since I'm using DBI 0.93)
Choice: C
Creating tables ... (, , )
Creating table Build_Update ... ok
Loading def file from SQL ... ok!
Saving def file ... ok!
Creating table Category ... failed (DBSQL (7793): Fatal Error: Unable to execute query:
(SQL Command from SQL.mysql goes in here)
. Reason: Commands out of sync; You can't run this command now at ./setup.cgi line 293
Now I know I'm connected to the database. I have to be or otherwise the first table would never get built. I'm not sure that the Build_Update.def is being properly created, because nothing is shown in $db_def or any of the other $db_ fields. Here is my Build_Update.def
package Links:
BSQL::Build_Update;
$db_name = 'Links';
$db_host = 'localhost';
$db_driver = 'mysql';
$db_user = 'user';
$db_pass = 'pass';
$db_key = '';
$db_table = 'Build_Update';
$db_track = '';
$attach_dir = '';
%db_def = (
);
%db_select_fields = (
);
%db_checkbox_fields = (
);
%db_radio_fields = (
);
1;
The rest of the def files all have Build_Upate in the $db_table, but I'm assuming that is because of the errors in loadinq the SQL commands - so I have no comfort level in relying on them.
When I do a describe Build_Update from the mysql monitor I get this:
+--------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+----------------------+------+-----+---------+-------+
| LinkID | int(10) unsigned | | PRI | 0 | |
| Hits | smallint(5) unsigned | | | 0 | |
| Votes | smallint(5) unsigned | | | 0 | |
| Rating | smallint(5) unsigned | | | 0 | |
+--------+----------------------+------+-----+---------+-------+
I'm assuming this is correct...???
I can cut and paste all the individual create table statements, so the problem doesn't appear to be in there.
I really think the problem is somewhere in the foreach loop that creates the tables and def files and how all the sql commands are getting issued. The individual pieces all seem to work, it's just that the program as a whole isn't. I just can't tell if it's a problem with creating the first .def file or if it's a problem with creating the second table. I'm guessing that by looking at the Build_Update.def file, that it is not correct and that's where the problem starts...
Jerry
Connecting to the database.
Please switch to the new connect method documenteded in DBI 0.84:
$dbh = DBI->connect($dsn).
We now emulate the call
$drh->connect('Links:localhost'),
but this exception will go away soon.
at /usr/local/lib/perl5/site_perl/DBI.pm line 352
Connecting ... ok!
(I'm not exactly sure what this error message means since I'm using DBI 0.93)
Choice: C
Creating tables ... (, , )
Creating table Build_Update ... ok
Loading def file from SQL ... ok!
Saving def file ... ok!
Creating table Category ... failed (DBSQL (7793): Fatal Error: Unable to execute query:
(SQL Command from SQL.mysql goes in here)
. Reason: Commands out of sync; You can't run this command now at ./setup.cgi line 293
Now I know I'm connected to the database. I have to be or otherwise the first table would never get built. I'm not sure that the Build_Update.def is being properly created, because nothing is shown in $db_def or any of the other $db_ fields. Here is my Build_Update.def
package Links:
BSQL::Build_Update; $db_name = 'Links';
$db_host = 'localhost';
$db_driver = 'mysql';
$db_user = 'user';
$db_pass = 'pass';
$db_key = '';
$db_table = 'Build_Update';
$db_track = '';
$attach_dir = '';
%db_def = (
);
%db_select_fields = (
);
%db_checkbox_fields = (
);
%db_radio_fields = (
);
1;
The rest of the def files all have Build_Upate in the $db_table, but I'm assuming that is because of the errors in loadinq the SQL commands - so I have no comfort level in relying on them.
When I do a describe Build_Update from the mysql monitor I get this:
+--------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+----------------------+------+-----+---------+-------+
| LinkID | int(10) unsigned | | PRI | 0 | |
| Hits | smallint(5) unsigned | | | 0 | |
| Votes | smallint(5) unsigned | | | 0 | |
| Rating | smallint(5) unsigned | | | 0 | |
+--------+----------------------+------+-----+---------+-------+
I'm assuming this is correct...???
I can cut and paste all the individual create table statements, so the problem doesn't appear to be in there.
I really think the problem is somewhere in the foreach loop that creates the tables and def files and how all the sql commands are getting issued. The individual pieces all seem to work, it's just that the program as a whole isn't. I just can't tell if it's a problem with creating the first .def file or if it's a problem with creating the second table. I'm guessing that by looking at the Build_Update.def file, that it is not correct and that's where the problem starts...
Jerry
