SEO Mod SQL ERROR

Download and support for PhpBB3 Forum SEO
Cypriotmatrix
BBCoder II
BBCoder II
Posts: 27
Joined: 15 Oct 2012, 11:56
BBCodes: 0

SEO Mod SQL ERROR

Post by Cypriotmatrix »

Hi all,

I went in to add all the SEO Key Words and description for each forum category and Forum, went to submit and I got the following SQL Error:

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'forum_seo_key' in 'field list' [1054]

SQL

UPDATE phpbb_forums SET parent_id = 0, forum_type = 0, forum_status = 0, forum_parents = '', forum_name = 'General Topics', forum_link = '', forum_desc = '', forum_desc_uid = '', forum_desc_options = 7, forum_desc_bitfield = '', forum_seo_key = 'Cyprus Forum, Cyprus Chat, Cyprus, Cyprus Sport, Cyprus Jokes, Cyprus Music, Cyprus Entertainment, Cyprus Music, Cyprus Tourism, Cyprus Classifieds', forum_seo_desc = 'Cyprus Forum - General Topics\nChat and debate about anything and everything!', forum_seo_bottom = '', forum_rules = '', forum_rules_uid = '', forum_rules_options = 7, forum_rules_bitfield = '', forum_rules_link = '', forum_image = '', forum_style = 0, display_subforum_list = 1, display_on_index = 0, forum_topics_per_page = 0, enable_indexing = 1, enable_icons = 0, enable_prune = 0, prune_days = 7, prune_viewed = 7, prune_freq = 1, forum_flags = 48 WHERE forum_id = 6

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 1238
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 189
CALL: acp_forums->update_forum_data()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_forums->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()
I don't know what all this means or how to fix it.

Can someone please help me so that I can get this mod working?

I am planning to launch my forum but only after I fix any SEO issues.
User avatar
Stoker
Site Admin
Site Admin
Posts: 3521
Joined: 12 May 2008, 21:26
BBCodes: 239
Favourite BBCode: Anipro
Favourite MOD: PrettyPhoto
Location: Denmark

SEO Mod SQL ERROR

Post by Stoker »

Try run the installer
Board rules! No PM support
Cypriotmatrix
BBCoder II
BBCoder II
Posts: 27
Joined: 15 Oct 2012, 11:56
BBCodes: 0

SEO Mod SQL ERROR

Post by Cypriotmatrix »

Stoker wrote:Try run the installer
Dis that!

I installed using AutoMod. I clicked install and it said that it installed successfully.

Is there something I am missing here? :?
User avatar
Stoker
Site Admin
Site Admin
Posts: 3521
Joined: 12 May 2008, 21:26
BBCodes: 239
Favourite BBCode: Anipro
Favourite MOD: PrettyPhoto
Location: Denmark

SEO Mod SQL ERROR

Post by Stoker »

When installing with automod you are told to run an installer.
You need to do this to create the database entries.
Board rules! No PM support
Cypriotmatrix
BBCoder II
BBCoder II
Posts: 27
Joined: 15 Oct 2012, 11:56
BBCodes: 0

SEO Mod SQL ERROR

Post by Cypriotmatrix »

Stoker wrote:When installing with automod you are told to run an installer.
You need to do this to create the database entries.
Yep I saw the instructions and ran the install.php and now the SEO Mod works.

Hopefully it will also bring good results for the forum.

Content, content, content

Boy forums are hard work! :)