SCHEMA_NOT_EXIST

Having trouble installing ModphpBB3 - Post any questions or issues in here.
themandimi
Forum Member
Forum Member
Posts: 17
Joined: Mon Jan 12, 2009 10:02 am

SCHEMA_NOT_EXIST

Post 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?
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: SCHEMA_NOT_EXIST

Post 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.
themandimi
Forum Member
Forum Member
Posts: 17
Joined: Mon Jan 12, 2009 10:02 am

Re: SCHEMA_NOT_EXIST

Post by themandimi »

alright! thanks!
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: SCHEMA_NOT_EXIST

Post 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.
You do not have the required permissions to view the files attached to this post.
themandimi
Forum Member
Forum Member
Posts: 17
Joined: Mon Jan 12, 2009 10:02 am

Re: SCHEMA_NOT_EXIST

Post 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)
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: SCHEMA_NOT_EXIST

Post 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.
themandimi
Forum Member
Forum Member
Posts: 17
Joined: Mon Jan 12, 2009 10:02 am

Re: SCHEMA_NOT_EXIST

Post by themandimi »

not the same db, but the db is in the same spot.
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: SCHEMA_NOT_EXIST

Post 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.
themandimi
Forum Member
Forum Member
Posts: 17
Joined: Mon Jan 12, 2009 10:02 am

Re: SCHEMA_NOT_EXIST

Post 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_
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: SCHEMA_NOT_EXIST

Post by LDM »

I'm guessing it could be a conflict or the /cache needs a purge/delete files to reflect the changes.
themandimi
Forum Member
Forum Member
Posts: 17
Joined: Mon Jan 12, 2009 10:02 am

Re: SCHEMA_NOT_EXIST

Post 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);
?>
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: SCHEMA_NOT_EXIST

Post 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.
themandimi
Forum Member
Forum Member
Posts: 17
Joined: Mon Jan 12, 2009 10:02 am

Re: SCHEMA_NOT_EXIST

Post by themandimi »

i have no idea, nothing else changed...
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: SCHEMA_NOT_EXIST

Post by LDM »

So is it a conversion in the new database or a fresh install?
themandimi
Forum Member
Forum Member
Posts: 17
Joined: Mon Jan 12, 2009 10:02 am

Re: SCHEMA_NOT_EXIST

Post by themandimi »

the new database is a complete fresh install, made of the modded.sql file provided in the download.
Post Reply