problemen met advanced links mod

[Ramonmartin]

ik heb net de advanced links mod geinstalleerd die heb ik op http://www.phpbb2.de gevonden en nou geeft hij de volgende error als ik onderaan op links klik,

Could not query links list

DEBUG MODE

SQL Error : 1054 Unknown column 'link_category' in 'field list'

SELECT link_category FROM phpbb_links WHERE link_active = 1 AND link_category = 1

Line : 674
File : /data/members/paid/a/u/autoproblemen.com/htdocs/www/links.php


En als ik in het adminpaneel in de categorie links op management klik krijg ik de volgende error,

Couldn not query links list.

DEBUG MODE

SQL Error : 1054 Unknown column 'l.user_id' in 'where clause'

SELECT l.*, u.username FROM phpbb_links l, phpbb_users u WHERE l.user_id = u.user_id ORDER BY link_id DESC LIMIT 0, 10

Line : 168
File : /data/members/paid/a/u/autoproblemen.com/htdocs/www/admin/admin_links.php


Wie kan me hiermee helpen want ik vindt het maar niet wat het kan zijn.

Alvast bedankt

[Luuk]

Heb je de SQL wel vgoed uitgevoerd?

[Fear2]

Dat lijkt mij ook,
Is ook duidelijk af te lezen in de error

Code: Selecteer alles

SQL Error : 1054 Unknown column 'link_category' in 'field list' 

[Ramonmartin]

als ik sql database wil updaten krijg ik dit te staan

This list is a result of the SQL queries needed for the Advanced Links MOD

[Error or Already added] line: 1 , CREATE TABLE phpbb_link_categories ( cat_id mediumint(8) unsigned NOT NULL auto_increment, cat_title varchar(100) NOT NULL default '', cat_order mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (cat_id), KEY cat_order (cat_order))
[Error or Already added] line: 2 , CREATE TABLE phpbb_links ( link_id mediumint(8) unsigned NOT NULL auto_increment, link_title varchar(100) NOT NULL default '', link_desc varchar(255) default NULL, link_category mediumint(8) unsigned NOT NULL default '0', link_url varchar(100) NOT NULL default '', link_logo_src varchar(120) default NULL, link_joined int(11) NOT NULL default '0', link_active tinyint(1) NOT NULL default '0', link_hits int(10) unsigned NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', user_ip varchar(8) NOT NULL default '', last_user_ip varchar(8) NOT NULL default '', PRIMARY KEY (link_id))
[Error or Already added] line: 3 , INSERT INTO phpbb_link_categories VALUES (1, 'Arts', 1)
[Error or Already added] line: 4 , INSERT INTO phpbb_link_categories VALUES (2, 'Business', 2)
[Error or Already added] line: 5 , INSERT INTO phpbb_link_categories VALUES (3, 'Children and Teens', 3)
[Error or Already added] line: 6 , INSERT INTO phpbb_link_categories VALUES (4, 'Computers', 4)
[Error or Already added] line: 7 , INSERT INTO phpbb_link_categories VALUES (5, 'Games', 5)
[Error or Already added] line: 8 , INSERT INTO phpbb_link_categories VALUES (6, 'Health', 6)
[Error or Already added] line: 9 , INSERT INTO phpbb_link_categories VALUES (7, 'Home', 7)
[Error or Already added] line: 10 , INSERT INTO phpbb_link_categories VALUES (8, 'News', 8)
[Error or Already added] line: 11 , INSERT INTO phpbb_links VALUES (1, 'phpBB Official Website', 'Official phpBB Website', 4, 'http://www.phpbb.com/', 'images/links/phpBB_88a.gif', 1102623273, 1, 0, 2, '', '')
[Error or Already added] line: 12 , INSERT INTO phpbb_links VALUES (2, 'phpbb-tw.net', 'Unofficial phpBB Chinese Support Centre', 4, 'http://phpbb-tw.net', 'images/links/phpbb-tw_logo88a.gif', 1102623273, 1, 0, 2, '', '')
[Error or Already added] line: 13 , INSERT INTO phpbb_links VALUES (3, 'phpbb2.de', 'Your Source for phpBB2 Stuff', 4, 'http://www.phpbb2.de', 'images/links/phpbb2_de_logo.gif', 1102623273, 1, 0, 2, '', '')
[Error or Already added] line: 14 , INSERT INTO phpbb_links VALUES (4, 'Forumimages.com', 'Forumimages.com', 4, 'http://www.forumimages.com', 'images/links/forum_images_banner_88x31.gif', 1102623273, 1, 0, 2, '', '')
[Error or Already added] line: 15 , CREATE TABLE phpbb_link_config ( config_name varchar(255) NOT NULL default '', config_value varchar(255) NOT NULL default '' )
[Added/Updated] line: 16 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('site_logo', 'http://www.autoproblemen.com/images/lin ... ogo88a.gif')
[Added/Updated] line: 17 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('site_url', 'http://www.autoproblemen.com/')
[Added/Updated] line: 18 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('width', '88')
[Added/Updated] line: 19 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('height', '31')
[Added/Updated] line: 20 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('linkspp', '10')
[Added/Updated] line: 21 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_interval', '6000')
[Added/Updated] line: 22 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_logo_num', '10')
[Added/Updated] line: 23 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('display_links_logo', '1')
[Added/Updated] line: 24 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('email_notify', '1')
[Added/Updated] line: 25 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('pm_notify ', '0')
[Added/Updated] line: 26 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('lock_submit_site', '0')
[Added/Updated] line: 27 , INSERT INTO phpbb_link_config (config_name, config_value) VALUES ('allow_no_logo', '0')

moet ik nu iets in de database wissen en daarna opnieuw dit uitvoeren of niet.

[Ramonmartin]

Probleem is opgelost er stond iets verkeerd in de sql database.