UBB.Developers Forums UBB.threads 6 V6 Modifications Forum Design Integration TLD Bv2.1 Released - Threads Links Directory

Hi guys,

Okay I installed it in the /ubbthreads directory. I clicked on "links administration" and this is what followed:

=======================

If you have NOT already created your database tables and this is your first install, you can do so by clicking here. :: So I did.

=======================

Next I got this:

=======================

SQL ERROR: Thu, Jan 08 2004 15:55:28 -0500 Unable to do_query: CREATE TABLE w3t_links_categories ( cat_id int(11) NOT NULL auto_increment, parent_id int(11) default NULL, title varchar(50) NOT NULL default '', cat_desc varchar(60) default NULL '', cat_order tinyint(10) NOT NULL default '0', PRIMARY KEY (cat_id) )
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''', cat_order tinyint(10) NOT NULL defaSQL ERROR: Thu, Jan 08 2004 15:55:28 -0500 Unable to do_query: CREATE TABLE w3t_links_links ( lid int(11) NOT NULL auto_increment, cat_id int(11) default NULL, approved tinyint(4) NOT NULL default '1', title varchar(100) NOT NULL default '', url varchar(100) NOT NULL default '', description text NOT NULL, date_added int(11) unsigned NOT NULL default '0', name varchar(100) NOT NULL default '', email varchar(100) NOT NULL default '', hits int(11) NOT NULL default '0', user_number int( 11 ) NOT NULL default '', member char(2) NOT NULL default '', linkratingsummary double(6,4) NOT NULL default '0.0000', totalvotes int(11) NOT NULL default '0', PRIMARY KEY (lid) )
Table 'w3t_links_links' already existsSQL ERROR: Thu, Jan 08 2004 15:55:28 -0500 Unable to do_query: CREATE TABLE w3t_links_favorites ( num int(9) unsigned NOT NULL auto_increment, lid int(9) unsigned NOT NULL default '0', uid int(9) unsigned NOT NULL default '0', PRIMARY KEY (num), KEY FAV_indx1 (uid) )
Table 'w3t_links_favorites' already existsDatabase tables have been created. You can now add categories and links.

========================

and when I clicked on "Links Home" in the navigation bar I got this:

========================

SQL ERROR: Thu, Jan 08 2004 15:57:24 -0500 Unable to do_query: SELECT * FROM w3t_links_categories WHERE parent_id = '0' ORDER BY 'cat_order'
Table 'flighta_thread.w3t_links_categories' doesn't exist
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/flighta/public_html/ubbthreads/links_show_cat.php on line 66

=======================

It looks like the w3t_ table(s) didn't create automatically? Don't suppose there are any more ideas? Sorry, I wish it had gone smoothly.

Thanks,

Jason