SQL error on install

Current Version: 1.0.6
Released: 09.01.10
Forum rules
Before creating a new support thread, please take a look in the board3 Portal FAQ and use the search!
Many questions have already been answered.
Locked

Topic author
Myaj
Active Member
Posts: 17
Joined: 23. October 2008 04:53

SQL error on install

Post by Myaj »

Your Portal Version: 1.0.2
Your phpBB Type: Premodded phpBB
MODs installed: Yes
Your knowledge: Basic Knowledge
Boardlink: http://www.hoofprintsacrosswi.com/forum

PHP Version: phpbb3

What have you done before the problem was there?
Followed install instructions

What have you already tryed to solve the problem?
Re-tried install 3 times, searched forums, tried both 1.0.1 and 1.0.2 installs AND the "alternative install" I found in another thread with the same error. Purged cache.

Description and Message
Well, same problem everyone else is having from what it looks like on the forum.

I've tried checking and rechecking, completely restoring files to pre-mod and starting over, starting over with the different install.

No matter what I do, when I go to run the forum/install_portal/install.php I get this error:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Table 'hoofprin_hoofprinphpBB3.phpbb_portal_config' doesn't exist [1146]

SQL

SELECT config_value as version FROM phpbb_portal_config WHERE config_name = 'portal_version' LIMIT 1

BACKTRACE

FILE: includes/db/mysql.php
LINE: 133
CALL: dbal_mysql->sql_error()

FILE: includes/db/mysql.php
LINE: 180
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 145
CALL: dbal_mysql->_sql_query_limit()

FILE: install_portal/install.php
LINE: 51
CALL: dbal_mysql->sql_query_limit()


Any help would be greatly appreciated, as my board is pretty much stuck here until I get this working and I still have a lot of work to do! :)[/i]
User avatar

Ice
Former Team Member
Posts: 359
Joined: 20. January 2008 23:43
Location: England, United Kingdom

Re: SQL error on install

Post by Ice »

Hmm, the error should be suppressed but obviously it is not. I'll see what I can come up with.

For the mean time, open install.php and delete:

Code: Select all

			FROM ' . PORTAL_CONFIG_TABLE . "
			WHERE config_name = 'portal_version'";
	$result = @$db->sql_query_limit( $sql, 1 );
	$version = $db->sql_fetchrow( $result );
	if( sizeof( $version ) )
	{
		$old_version = strtolower($version['version']);
	}
	else
	{
		$db->sql_freeresult( $result );
		$sql = 'SELECT config_value as version 
				FROM ' . CONFIG_TABLE . "
				WHERE config_name = 'portal_version'";
		$result = @$db->sql_query_limit( $sql, 1 );
		$version = $db->sql_fetchrow( $result );
		if( sizeof( $version ) )
		{
			$phpbb3portal = true;
			$old_version = ( strtolower($version['version']) == '1.1.0.b' ) ? '1.1.0b' : strtolower($version['version']) ;
		}
	}
	$db->sql_freeresult( $result );
Board3 Portal Dev & English Tech Support

Topic author
Myaj
Active Member
Posts: 17
Joined: 23. October 2008 04:53

Re: SQL error on install

Post by Myaj »

I'm starting with this:

Code: Select all

$old_version = 0;
	$phpbb3portal = false;
	$installed = $updated = $uninstalled =false;
	
	$sql = 'SELECT config_value as version 
			FROM ' . PORTAL_CONFIG_TABLE . "
			WHERE config_name = 'portal_version'";
	$result = @$db->sql_query_limit( $sql, 1 );
	$version = $db->sql_fetchrow( $result );
	if( sizeof( $version ) )
	{
		$old_version = strtolower($version['version']);
	}
	else
	{
		$db->sql_freeresult( $result );
		$sql = 'SELECT config_value as version 
				FROM ' . CONFIG_TABLE . "
				WHERE config_name = 'portal_version'";
When I delete what you stated above I have this:

Code: Select all

$old_version = 0;
	$phpbb3portal = false;
	$installed = $updated = $uninstalled =false;
	
	else
	{
		$db->sql_freeresult( $result );
		$sql = 'SELECT config_value as version 
				FROM ' . CONFIG_TABLE . "
				WHERE config_name = 'portal_version'";
Which gives me this error:
Parse error: syntax error, unexpected T_ELSE in /home/hoofprin/public_html/forum/install_portal/install.php on line 48

I tried deleting that else followed by the {, but that just gave me an error farther down the page. I don't know enough about the code to guess anymore at what to do?

Topic author
Myaj
Active Member
Posts: 17
Joined: 23. October 2008 04:53

Re: SQL error on install

Post by Myaj »

Dang, and now my entire board is giving that error about the missing table.. not just when I run the install.
User avatar

Ice
Former Team Member
Posts: 359
Joined: 20. January 2008 23:43
Location: England, United Kingdom

Re: SQL error on install

Post by Ice »

Hmm half the code I posted cut off, what I meant to say was that you need to delete:

Code: Select all

	$sql = 'SELECT config_value as version 
			FROM ' . PORTAL_CONFIG_TABLE . "
			WHERE config_name = 'portal_version'";
	$result = @$db->sql_query_limit( $sql, 1 );
	$version = $db->sql_fetchrow( $result );
	if( sizeof( $version ) )
	{
		$old_version = strtolower($version['version']);
	}
	else
	{
		$db->sql_freeresult( $result );
		$sql = 'SELECT config_value as version 
				FROM ' . CONFIG_TABLE . "
				WHERE config_name = 'portal_version'";
		$result = @$db->sql_query_limit( $sql, 1 );
		$version = $db->sql_fetchrow( $result );
		if( sizeof( $version ) )
		{
			$phpbb3portal = true;
			$old_version = ( strtolower($version['version']) == '1.1.0.b' ) ? '1.1.0b' : strtolower($version['version']) ;
		}
	}
	$db->sql_freeresult( $result );
Board3 Portal Dev & English Tech Support

Topic author
Myaj
Active Member
Posts: 17
Joined: 23. October 2008 04:53

Re: SQL error on install

Post by Myaj »

I was hoping it was as simple as it getting cut off :)

Thank you I'll try that edit and let you know if it works.

Topic author
Myaj
Active Member
Posts: 17
Joined: 23. October 2008 04:53

Re: SQL error on install

Post by Myaj »

Okay, that allowed me to run the installer, which looked perfect, then I deleted the install_portal folder.

Now I'm getting this error:
Fatal error: Call to undefined function: bbcode_nl2br() in /home/hoofprin/public_html/forum/portal/block/poll.php on line 323
User avatar

Ice
Former Team Member
Posts: 359
Joined: 20. January 2008 23:43
Location: England, United Kingdom

Re: SQL error on install

Post by Ice »

Strange as that function comes from the functions.php that should have been included already.

At the top of portal.php check there is the line

Code: Select all

include($phpbb_root_path . 'portal/includes/functions.'.$phpEx);
Board3 Portal Dev & English Tech Support

Topic author
Myaj
Active Member
Posts: 17
Joined: 23. October 2008 04:53

Re: SQL error on install

Post by Myaj »

Yes, it is there:

Code: Select all

define('IN_PHPBB', true);
define('IN_PORTAL', true);

$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';

$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
include($phpbb_root_path . 'portal/includes/functions.'.$phpEx);

$portal_config = obtain_portal_config();
For what its worth, the portal page came up perfect after the install... just with the note to delete the install folder. As soon as I deleted the install though, no more portal.

Topic author
Myaj
Active Member
Posts: 17
Joined: 23. October 2008 04:53

Re: SQL error on install

Post by Myaj »

Do you think if I backup to a different version it might work?
Locked

Return to “board3 Portal 1.0.x - English Support”