Fatal Error in Gdn_Database.Query();

jmcruz

Im using Vanilla Version 2.0.17.10. Installed it on localhost and uploaded via FTP but im getting this error:

Table 'p4one_6218754_bdsdb.GDN_Permission' doesn't exist
select * from GDN_Permission Permission limit 1
The error occurred on or near: /home/vol9/p4o.net/p4one_6218754/htdocs/library/database/class.database.php

232: $PDOStatement = $this->Connection()->query($Sql);

233: }

234:

235: if ($PDOStatement === FALSE) {

236: trigger_error(ErrorMessage($this->GetPDOErrorMessage($this->Connection()->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);

237: }

238:

239: $ReturnType = GetValue('ReturnType', $Options);

240:

Tried deleting lines in enabled plugins but still getting the same error. HELP! and Thanks in advance.

Tim

The GDN_Permission table is created when you install the software, so either you're pointing at the wrong database, or you didn't actually install Vanilla. Either way this is an odd problem.

You can try running the DB update script.

www.yourforum.com/utility/update (or www.yourforum.com/?p=utility/update)

jmcruz

I can actually see the table(gdn_permission) and the result with that update is a success but i'm still getting the same error.

Tim

1) is this the correct DB? p4one_6218754_bdsdb
2) Do you have a backtrace?

jmcruz

Yes, it is the correct database and what is a backtrace?

UnderDog

I think you have a problem with lowercase and UPPERCASE.
A backtrace can be found on the page you just quoted the errors from (the detailed bonk error page)

jmcruz

I'm pretty sure i typed dbname/username all with lowercase, i copy/paste them from the hosting server.

Anyway, here is the backtrace and thanks UnderDog and Tim.

/home/vol9/p4o.net/p4one_6218754/htdocs/library/database/class.database.phpPHP::Gdn_ErrorHandler();

[/home/vol9/p4o.net/p4one_6218754/htdocs/library/database/class.database.php:236] PHP::trigger_error();

[/home/vol9/p4o.net/p4one_6218754/htdocs/library/database/class.sqldriver.php:1584] Gdn_Database->Query();

[/home/vol9/p4o.net/p4one_6218754/htdocs/library/database/class.sqldriver.php:639] Gdn_SQLDriver->Query();

[/home/vol9/p4o.net/p4one_6218754/htdocs/applications/dashboard/models/class.permissionmodel.php:416] Gdn_SQLDriver->Get();

[/home/vol9/p4o.net/p4one_6218754/htdocs/applications/dashboard/models/class.permissionmodel.php:133] PermissionModel->PermissionColumns();

[/home/vol9/p4o.net/p4one_6218754/htdocs/applications/dashboard/models/class.usermodel.php:88] PermissionModel->CachePermissions();

[/home/vol9/p4o.net/p4one_6218754/htdocs/library/core/class.session.php:291] UserModel->DefinePermissions();

[/home/vol9/p4o.net/p4one_6218754/htdocs/library/core/class.auth.php:27] Gdn_Session->Start();

[/home/vol9/p4o.net/p4one_6218754/htdocs/bootstrap.php:186] Gdn_Auth->StartAuthenticator();

[/home/vol9/p4o.net/p4one_6218754/htdocs/index.php:28] PHP::require_once();

Tim

MySQL seems to sometimes get corrupt (apparently... its never happened to me). Look for some sort of database repair utility on your host.

jmcruz

I did a repair table thru dropdown and thru command line but to no avail, it's still showing the error. I even re-import all the tables. I'll try to make a fresh install of everything later and will update here asap. Please bear with me as i really wanted to use vanilla forum as my discussion board. Thanks again.

jmcruz

Ok, i did a fresh install of everything, i made a new database, i still can see the gdn_permission but sadly i am getting the same fatal error. I just don't know what to do anymore. Anyone? Thanks in advance.

jmcruz

By the way, everything works fine on my localhost.