Page 1 of 1

Manual SQL Table creation. Help please

Posted: 16. March 2010 19:29
by Chef_uk
Your Portal Version: 1.0.0RC3
Your phpBB Type: Standard phpBB3
MODs installed: No
Your knowledge: Basic Knowledge

What have you done before the problem was there?


What have you already tryed to solve the problem?
Created SQL Table within the database but have no idea what info needs placing within the table.

Description and Message
Hi, i've installed the mod (v1.0.5) without problems but visiting the new url gives me the Table 'MYDATABASE.******_portal_config' doesn't exist [1146]

Having searched around i see others have the same problem but no common fix is given so I go into phpMyAdmin and create the table manually but am stuck at the point where i fill in the table with info so could someone please post up the table's contents so i can get it to work please :) Whatever i try i get the following error:

SQL ERROR [ mysql4 ] Unknown column 'config_name' in 'field list' [1054]

Re: Manual SQL Table creation. Help please

Posted: 16. March 2010 19:39
by Marc
Why don't you use the installer? It creates everything in the database.

Re: Manual SQL Table creation. Help please

Posted: 17. March 2010 19:10
by Chef_uk
I knew that :oops: working now, thanks.

Re: Manual SQL Table creation. Help please

Posted: 17. March 2010 23:55
by Chef_uk
A new problem with regards to it showing up in the ACP
[phpBB Debug] PHP Notice: in file /portal/includes/functions_version_check.php on line 38: include(./mods/board3_portal_check_version.php) [function.include]: failed to open stream: Not a directory
[phpBB Debug] PHP Notice: in file /portal/includes/functions_version_check.php on line 38: include(./mods/board3_portal_check_version.php) [function.include]: failed to open stream: Not a directory
[phpBB Debug] PHP Notice: in file /portal/includes/functions_version_check.php on line 38: include() [function.include]: Failed opening './mods/board3_portal_check_version.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php')
[phpBB Debug] PHP Notice: in file /portal/includes/functions_version_check.php on line 42: call_user_func(board3_portal_check_version::version) [function.call-user-func]: First argument is expected to be a valid callback
[phpBB Debug] PHP Notice: in file /adm/index.php on line 150: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
[phpBB Debug] PHP Notice: in file /adm/index.php on line 152: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
[phpBB Debug] PHP Notice: in file /adm/index.php on line 153: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
[phpBB Debug] PHP Notice: in file /adm/index.php on line 154: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3493)
Searching on here shows a similar problem that was solved by adding the code in to the functions.php file. I've checked mine and it is in there. Any ideas whats causing this?

Re: Manual SQL Table creation. Help please

Posted: 18. March 2010 00:55
by Chef_uk
Fixed it. For some reason the portal/adm/mods folder that contains the board3_portal_check_version.php file was not uploading or rather not showing up. I had to add the board3_portal_check_version.php file directly inside the admin folder and edited the command to show this:

include($phpbb_admin_path . 'board3_portal_check_version.' . $phpEx);

Works fine now.