Bonk GDN fatal error

TheBest4U

i have problem
http://www.dk-peda.lv/sarunas/
what i need repair?

AJ_TheBest4U

Fatal Error in Gdn_DatabaseDebug.Connection();

An error occurred while attempting to connect to the database
SQLSTATE[42000] [1044] Access denied for user 'dkpeda_anri'@'193.46.236.34' to database 'dkpeda_forum'
The error occurred on or near: /home6/dkpeda/public_html/sarunas/library/database/class.database.php
56: $this->_Connection = new PDO(strtolower($this->Engine) . ':' . $this->Dsn, $this->User, $this->Password, $this->ConnectionOptions);
57: if($this->ConnectionOptions[1002])
58: $this->Query($this->ConnectionOptions[1002]);
59: } catch (Exception $ex) {
60: trigger_error(ErrorMessage('An error occurred while attempting to connect to the database', $this->ClassName, 'Connection', $ex->getMessage()), E_USER_ERROR);
61: }
62: }
63:
64: return $this->_Connection;

luc

Well, it says it all. Wrong user or password, or no rights to access the database.

AJ_TheBest4U

but yesterday everything was fine. today do not work.


sorry 4 my english! im from Latvia!

AJ_TheBest4U

now i have:

Unknown column 'c.PermissionCategoryID' in 'on clause'
select distinct c.CategoryID as `CategoryID`
from GDN_Category c
inner join GDN_Permission _p on _p.JunctionID = c.PermissionCategoryID
inner join GDN_UserRole _ur on _p.RoleID = _ur.RoleID
where (_ur.UserID = :_urUserID
and (_p.`Vanilla.Discussions.View` = :_pVanillaDiscussionsView))

UnderDog

sorry 4 my english! im from Latvia!

Don't worry about your english, it's fine.
What I would do is go over all the MySQL username / host settings.
This seems strange to me:
'dkpeda_anri'@'193.46.236.34' but that might be something I don't know about.
Add a new MySQL user
Add that user to your 'dkpeda_forum' database
Alter the config settings
Let's see if that works

AJ_TheBest4U

i have dkpeda_anri user with all permisions!

AJ_TheBest4U

OK
i hope it helps me, but no
i install a new version 2.0.18.b2


Fatal Error in Gdn_DatabaseDebug.Query();

Unknown column 'c.LastCommentID' in 'on clause'
select c.*, lc.DateInserted as `DateLastComment`
from GDN_Category c
left join GDN_Comment lc on c.LastCommentID = lc.CommentID
order by c.TreeLeft asc
The error occurred on or near: /home6/dkpeda/public_html/sarunas/library/database
Method: Query

*snip*

UnderDog

I took some of your backtrace away, because it's less relevant to your problem.

It's good that you pasted it though and keep doing it for all your future problems.
The more information the better :-)

Now the problem:
Unknown column 'c.LastCommentID' in 'on clause'
This means that part of the database is missing, specifically the LastCommentID field.

It also means you've solved your connection problems and you can connect to the database :-)

AJ_TheBest4U

ok
i recovered the missing fields!
but NOW i have the same problem who was in the begining
i didnt do anything her..
http://www.dk-peda.lv/sarunas/

Fatal Error in Gdn_DatabaseDebug.Query();

Table 'dkpeda_forum.GDN_UserCategory' doesn't exist
select c.*, lc.DateInserted as `DateLastComment`, uc.DateMarkedRead as `UserDateMarkedRead`, uc.Unfollow as `Unfollow`
from GDN_Category c
left join GDN_Comment lc on c.LastCommentID = lc.CommentID
left join GDN_UserCategory uc on c.CategoryID = uc.CategoryID and uc.UserID = 1
order by c.TreeLeft asc
The error occurred on or near: /home6/dkpeda/public_html/sarunas/library/database/class.database.php
284: $PDOStatement = $this->Connection()->query($Sql);
285: }
286:
287: if ($PDOStatement === FALSE) {
288: trigger_error(ErrorMessage($this->GetPDOErrorMessage($this->Connection()->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
289: }
290:
291: // Did this query modify data in any way?
292: if ($ReturnType == 'ID') {
Backtrace:
[/home6/dkpeda/public_html/sarunas/library/database/class.database.php:288] PHP::Gdn_ErrorHandler();
[/home6/dkpeda/public_html/sarunas/plugins/Debugger/class.database.debug.php:98] Gdn_Database->Query();
[/home6/dkpeda/public_html/sarunas/library/database/class.sqldriver.php:1648] Gdn_DatabaseDebug->Query();
[/home6/dkpeda/public_html/sarunas/library/database/class.sqldriver.php:673] Gdn_SQLDriver->Query();
[/home6/dkpeda/public_html/sarunas/applications/vanilla/models/class.categorymodel.php:79] Gdn_SQLDriver->Get();
[/home6/dkpeda/public_html/sarunas/applications/vanilla/models/class.categorymodel.php:36] CategoryModel::Categories();
[/home6/dkpeda/public_html/sarunas/applications/vanilla/models/class.categorymodel.php:402] CategoryModel::CategoryWatch();
[/home6/dkpeda/public_html/sarunas/applications/vanilla/modules/class.categoriesmodule.php:24] CategoryModel->GetFull();
[/home6/dkpeda/public_html/sarunas/library/core/class.controller.php:454] CategoriesModule->__construct();
[/home6/dkpeda/public_html/sarunas/applications/vanilla/controllers/class.discussionscontroller.php:87] Gdn_Controller->AddModule();
[/home6/dkpeda/public_html/sarunas/library/core/class.dispatcher.php:291] DiscussionsController->Index();
[/home6/dkpeda/public_html/sarunas/index.php:51] Gdn_Dispatcher->Dispatch();
Queries:
select u.*
from GDN_User u
where u.UserID = '1'; 0.001770s
set names 'utf8'; 0.007010s
show columns from `GDN_User`; 0.009043s
update GDN_User User set
DateLastActive = '2011-06-29 14:57:22',
DateUpdated = '2011-06-29 14:57:22'
where UserID = '1'; 0.197070s
select c.*, lc.DateInserted as `DateLastComment`, uc.DateMarkedRead as `UserDateMarkedRead`, uc.Unfollow as `Unfollow`
from GDN_Category c
left join GDN_Comment lc on c.LastCommentID = lc.CommentID
left join GDN_UserCategory uc on c.CategoryID = uc.CategoryID and uc.UserID = 1
order by c.TreeLeft asc; 0.000000s
Variables in local scope:
[Sql] 'select c.*, lc.DateInserted as `DateLastComment`, uc.DateMarkedRead as `UserDateMarkedRead`, uc.Unfollow as `Unfollow`
from GDN_Category c
left join GDN_Comment lc on c.LastCommentID = lc.CommentID
left join GDN_UserCategory uc on c.CategoryID = uc.CategoryID and uc.UserID = 1
order by c.TreeLeft asc'
[InputParameters] array (
)
[Options] array (
'ReturnType' => 'DataSet',
)
[ReturnType] 'DataSet'
[PDOStatement] false
Need Help?
If you are a user of this website, you can report this message to a website administrator.
If you are an administrator of this website, you can get help at the Vanilla Community Forums.
Additional information for support personnel:
Application: Vanilla
Application Version: 2.0.18b2
PHP Version: 5.2.16
Operating System: Linux
Server Software: Apache
User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.772.0 Safari/535.1
Request Uri: /sarunas/
Controller: Gdn_DatabaseDebug
Method: Query

AJ_TheBest4U

???

shyaminayesh

i think your vanilla exceed maximum sql database connection count .... so try increase your database connection count in the hosting ...

peregrine

@AJ_TheBest4U said:
OK
i hope it helps me, but no
i install a new version 2.0.18.b2

so where did you get this version?

also try /utility/update - see docs in installation

TheBest4U

as ussualy http://vanillaforums.org/download

peregrine

I've never seen that version - I thought it was 2.0.18.4

what number does it say in index.php? It seems unusual to have a beta version in the main download button, if what you say is true, I think their versioning got messed up and they put a beta version in the wrong place.

erase the ini files in your /cache and try the utility update.

peregrine

also Table 'dkpeda_forum.GDN_UserCategory' doesn't exist

do you have UserCategory in the correct database?

TheBest4U

now its ok! all work fine! tnx

peregrine

so what was your solution, if you know?

TheBest4U

it was a long time ago, I put back the previous version and everything worked fine

peregrine

@TheBest4U

oh, I didn't realize that @shyaminayesh was necroposting. sorry.

@underdog - necroposter alert.

and madera12 may be a troll.