Page 1 of 1

SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't exist

Posted: 7. October 2011 16:06
by Anteli
After making changes for custom side block in ACP I clicked "return to board" and I got following error message:

Code: Select all

SQL ERROR [ mysqli ]

Table 'np43689_foorumi.PORTAL_CONFIG_TABLE' doesn't exist [1146]

SQL

SELECT config_name, config_value FROM PORTAL_CONFIG_TABLE

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: portal/includes/functions.php
LINE: 26
CALL: dbal_mysqli->sql_query()

FILE: index.php
LINE: 41
CALL: obtain_portal_config()
Any ideas for this one? Thanks!

Re: SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't e

Posted: 7. October 2011 22:49
by Marc
obtain_portal_config() doesn't get called by index.php in Board3 Portal 2.0.0b1. If you updated from Board3 Portal 1.0.6, make sure that you removed old Board3 Portal MODs from your board.

Re: SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't e

Posted: 8. October 2011 00:53
by Anteli
Marc wrote:obtain_portal_config() doesn't get called by index.php in Board3 Portal 2.0.0b1. If you updated from Board3 Portal 1.0.6, make sure that you removed old Board3 Portal MODs from your board.
Yes, I updated from 1.0.6.

In update.xml there was the list about files I should delete. I checked I have deleted all these files. Did you mean these files?

Code: Select all

Delete: adm/style/acp_portal.html 
Delete: language/en/mods/additional_blocks.php 
Delete: language/en/mods/info_acp_additional_blocks.php 
Delete: language/en/mods/install_portal.php 
Delete: language/en/mods/lang_portal.php 
Delete: language/en/mods/lang_portal_acp.php 
Delete: portal/block/*.* 
Delete: styles/prosilver/template/portal/portal_center.html 
Delete: styles/prosilver/template/portal/portal_left.html 
Delete: styles/prosilver/template/portal/portal_right.html 
Delete: styles/prosilver/template/portal/block/*.* 
Delete: styles/prosilver/theme/images/portal/mini_cal_icon_left_arrow.png 
Delete: styles/prosilver/theme/images/portal/mini_cal_icon_right_arrow.png 
Delete: styles/prosilver/theme/images/portal/portal_login.png 
Delete: styles/prosilver/theme/images/portal/portal_minical.png 
Delete: styles/prosilver/theme/images/portal/portal_random.png 
Delete: styles/prosilver/theme/images/portal/portal_stats.png 
Btw, on this forum, you should refresh imagesets or fix imagesets.cfg because I can see just about 3/4 of buttons. :D

Re: SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't e

Posted: 8. October 2011 08:30
by Marc
Make sure you also edited includes/functions.php as directed by install.xml.

Did you have the Portalview MOD installed? If yes, you should also remove those edits.

Re: SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't e

Posted: 9. October 2011 17:18
by Anteli
Marc wrote:Make sure you also edited includes/functions.php as directed by install.xml.

Did you have the Portalview MOD installed? If yes, you should also remove those edits.
includes/functions.php is just like install.xml wants it to be. I don't have Portalview MOD installed.

Re: SQL ERROR [ mysqli ] - 'x.PORTAL_CONFIG_TABLE' doesn't e

Posted: 9. October 2011 18:54
by archivar
You must remove all extra modules (addons for portal) and code that access the old portal.