Page 1 of 2

SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 12:32 pm
by themandimi
Hello everyone,
first i tried to do this in the way of converting my old phpbb3 board to this version but i got the white screen with "SCHEMA_NOT_EXIST". I thought it was a problem with converting so i tried making a new one and just got the same issue. Is there anyone able to help me with this?

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 12:55 pm
by LDM
Those instructions are for 1.0.3 and 1.0.4, 1.0.5 instructions are not made yet.

I think it's advertisement manager giving you that error, give me an hour or so and I will look into it.

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 12:58 pm
by themandimi
alright! thanks!

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 1:23 pm
by LDM
Unzip the zip attached, and overwrite root/ads with this one.

Inside is the schema files to write the tables. Once written, you may delete the schema folder inside /ads folder and the create_schema_files.php.

Once that is running you may find another error as there were a few more mods added to 1.0.5, but see how you go.

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 1:50 pm
by themandimi
SQL ERROR [ mysql4 ]

Access denied for user '*******'@'localhost' (using password: YES) [1045]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
the config file is the same as the other forum, just different prefix. i dont see how this can happen (the new forum is also in a new database, instead of name_db its name_test)

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 1:55 pm
by LDM
If the forum is using the same database as the other forum (without mods) there wil be conflict as the old forum doesn't have the modification tables in the database.

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 1:56 pm
by themandimi
not the same db, but the db is in the same spot.

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 2:05 pm
by LDM
So it's just using another prefix? I'm not too sure without seeing the tables. The error posted above is where the incorrect settings are in config.php.

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 2:10 pm
by themandimi
so my phpmyadmin has 2 databasses
db & test

both are accessed by the same pass

db is my current forum wich works perfectly

test is the new one to try it out on.

db has prefixes phpbb2_ and test has prefixes phpbb_

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 2:12 pm
by LDM
I'm guessing it could be a conflict or the /cache needs a purge/delete files to reflect the changes.

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 2:55 pm
by themandimi
cache is emtied. i dont see what conflict it could be...

config for test forum
<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '';
$dbname = :o
$dbuser = :o
$dbpasswd = :o
';

$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
//define('DEBUG', true);
//define('DEBUG_EXTRA', true);
?>
config for normal forum
<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '';
$dbname = :o
$dbuser = :o
$dbpasswd = :o
$table_prefix = 'phpbb2_';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 3:03 pm
by LDM
I just edited post as adding username and passes for database will surely get accessed by anyone reading.

If it's not connecting with database now, how did you get error for schema file from ad manager.

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 3:04 pm
by themandimi
i have no idea, nothing else changed...

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 3:11 pm
by LDM
So is it a conversion in the new database or a fresh install?

Re: SCHEMA_NOT_EXIST

Posted: Mon Jan 12, 2009 3:12 pm
by themandimi
the new database is a complete fresh install, made of the modded.sql file provided in the download.