There are 2 little bugs in links.inc.php:

line 141 and line 1167 contains a double }
change it to a single }

what the first }} do .. I dont now but the second break the breadcrumb link

The same problem in links_admin.php on line 805 and links_redirect.php line 157

I tried running Blasskaaks query



to create the table - as I get this:

We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: Table 'galactiF.ubbt_links_links' doesn't exist
SQL Error #: 1146
Query: SELECT lid,cat_id FROM ubbt_links_links WHERE approved = '1'

but it says :

#1064 - 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 'CREATE TABLE ubbt_links_categories

Anyone know what I'm doing wrong to get this error ? I REALLY want to get this working.

If I remember right there's a good number of little bugs here and there in the code this is based on. If I ever get time I'll look at updating it.

?? What platform are you running on?

It looks like you didn't create all the tables, or they are of a different prefix

Oh, the prefix is the same.

It's just every time I run the query to create the tables it doesn't do it in phpMyAdmin

I have allmost the same problem. Centos 5.0 latest mysql.

SQL-query:

CREATE TABLE ubbt_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 '0',
memberchar( 2 ) NOT NULL default '',
linkratingsummary double( 6, 4 ) NOT NULL default '0.0000',
totalvotes int( 11 ) NOT NULL default '0',
PRIMARY KEY ( lid )
) CREATE TABLE ubbt_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 )
) CREATE TABLE ubbt_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 )
)

MySQL retourneerde:

#1064 - 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 'CREATE TABLE ubbt_links_categories
(

cat_id int(11) NOT NULL auto_inc' at line 21

Can you try running each create table on its own and see which one it chokes on?

I did rename the w3t prefix to ubbt, I also updated the code itselve to use that new prefix.

Are you having the same problems? Did anyone get it to install correctly?

I got to install correctly...

I changed the default prefix to ubbt_
created the tables manually

Seperately the tables create with no problems!?!

Same here.

Now all I need to do is get some of the display issues sorted.

Good, if I get time I'll look at it later this week, it really needs a few issues worked out

Great to hear Allen!

We are kinda planning on using this, but I held it back a little after hearing about the problems in it.

I use my old tables so I dont run the create process

Hi,
if one the Line

$config['tbprefix'] = "ubbt_"; // The Prefix to the Links tables

in the files links.inc.php, links_admin.inc.php, links_redirect.inc.php by

$config['tbprefix'] = "{$config['TABLE_PREFIX']}"; // The Prefix to the Links tables

substituted, one does not need before the installation only the files with the right Prefix edit.

Has someone test this under V7.3b4?