SEO Mod SQL ERROR

Modifications for phpBB3.
Try the Mods here and share Your own Mods
Forum rules
You dont have to use ModX or make your mod AutoMod compatible. A simple textfile is fine
But if you post Mods here You also have to give support
No Avatar
Cypriotmatrix Offline
BBCoder II
BBCoder II
Posts: 27
Joined: 15 Oct 2012, 11:56
Local time: Saturday 23:34
Last active: -

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 Online
Site Admin
Site Admin
Posts: 4,295
Joined: 12 May 2008, 21:26
Local time: Saturday 23:34
Last active: Online now
Favourite EXT: Forum Goal
Location: Denmark

SEO Mod SQL ERROR

Post by Stoker »

Try run the installer
~ The greatest achievement in life is to inspire ~
Regards Stoker
No Avatar
Cypriotmatrix Offline
BBCoder II
BBCoder II
Posts: 27
Joined: 15 Oct 2012, 11:56
Local time: Saturday 23:34
Last active: -

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 Online
Site Admin
Site Admin
Posts: 4,295
Joined: 12 May 2008, 21:26
Local time: Saturday 23:34
Last active: Online now
Favourite EXT: Forum Goal
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.
~ The greatest achievement in life is to inspire ~
Regards Stoker
No Avatar
Cypriotmatrix Offline
BBCoder II
BBCoder II
Posts: 27
Joined: 15 Oct 2012, 11:56
Local time: Saturday 23:34
Last active: -

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! :)