Weblinks not adding

Regular Joined: Feb 16, 2004 Posts: 69

It says that the link was added. But when I go to the web link
administration it shows 0 links. This is PHP-Nuke Platinum v.6.9.1
Any suggestions?

Thanks!

Dss

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

I don't use it and am unfamiliar with it. If it is set up the same, edit sql_layer.php and set $sql_debug to 1 and see if it shows an sql error when you try to add the link.

Posted: Mon Oct 18, 2004 8:59 am

Thanks for your help as usual Raven.
Here is what i get

SQL query: select radminlink, radminsuper from nuke_authors where aid='larry'
SQL query: select url from nuke_links_links where url='http://www.links.com'
SQL query: insert into nuke_links_links values (NULL, '1', '0', 'test', '', 'http://www.links.com', 'test', now(), 'test', 'larry@links.com', '0', '', 0, 0, 0)
It acts like it adds it..but then it shows 0 in database.

Dss

Posted: Mon Oct 18, 2004 9:01 am

Check the table with phpmyadmin and verify that the link is added or not.

Posted: Mon Oct 18, 2004 9:17 am

The table is empty.

Dss

Posted: Mon Oct 18, 2004 11:26 am

Use phpmyadmin and paste this into the SQL window. That should tell you the error, if there is on.

Code:

insert into nuke_links_links values (NULL, '1', '0', 'test', '', 'http://www.links.com', 'test', now(), 'test', 'larry@links.com', '0', '', 0, 0, 0)

Posted: Mon Oct 18, 2004 11:38 am

Here is the error

Code:




Error





SQL-query : 





INSERT INTO nuke_links_links


VALUES (


NULL , '1', '0', 'test', '', 'http://www.links.com', 'test', now( ) , 'test', 'larry@links.com', '0', '', 0, 0, 0


)





MySQL said:





Column count doesn't match value count at row 1





Back

Posted: Mon Oct 18, 2004 12:34 pm

Your weblinks module is not in sync with the table schema. Your INSERT statement has 15 columns. How many are actually in the table?

Posted: Mon Oct 18, 2004 1:48 pm

There were 16 columns. I compared the fields to an orignal sql and dropped the one
that was in it. That fixed it! Thanks again my friend!!!!

Dss

Posted: Mon Oct 18, 2004 2:38 pm