database connection error |
Post Reply |
Author | |
skb
Newbie Joined: May 19 2016 Location: India Status: Offline Points: 7 |
Post Options
Thanks(0)
Posted: Nov 12 2018 at 1:33pm |
I have created a site with the 4 User packs 10-40.
Since my host does not support SQLite, I opted for MySQL for the database and configured it. Locally, I am able to use the pages but when I upload it to the web server, I get a Database Connection error Check connection parameters (user, password etc.) I tried importing the oedb.db through PhpMyAdmin but I get a Syntax error on line 1 where the database is initialised as "SQLite format 3". Any suggestions please ?
|
|
Total nerd
|
|
skb
Newbie Joined: May 19 2016 Location: India Status: Offline Points: 7 |
Post Options
Thanks(0)
|
My error log shows Access denied due to syntax error at Line 415 of file - WEFiles/Server/DB/DBTools/OEDBRequest.php
|
|
Total nerd
|
|
skb
Newbie Joined: May 19 2016 Location: India Status: Offline Points: 7 |
Post Options
Thanks(0)
|
On line 387 just below the "Overiddable functions"
this protected function is commented out /*protected function _getConnectParams() { if (OESQLBase::isLocalDB()) { global $oeLoginMySQL_Local; if (!isset($oeLoginMySQL_Local)) return null; return $oeLoginMySQL_Local; } else { global $oeLoginMySQL; if (!isset($oeLoginMySQL)) return null; return $oeLoginMySQL; } return null; }*/ If I remove the /* & */ I see a different error User management system is not yet initialized. First, open the Administration page in browser to initialize data. If I try to access admin page via the address bar, the Admin page opens up, but the User List is empty, and even record 1 for Admin is showing status as "error" and I cannot proceed further. If I try the "Edit Admin Account" link it gives me a 404 error.
Edited by skb - Nov 17 2018 at 10:32am |
|
Total nerd
|
|
Dmit OE
Admin Group Joined: May 31 2012 Status: Offline Points: 5283 |
Post Options
Thanks(0)
|
Hi, Please check whether you have MySQLi (attention to "i") installed on your server. If you only have plain MySQL it won't work
|
|
skb
Newbie Joined: May 19 2016 Location: India Status: Offline Points: 7 |
Post Options
Thanks(0)
|
I have MySQL. But I’ve managed to install phplite and use the pages with a SQLite database.
My other question is I’m developing a responsive site without a template. When I add the php pages will the responsiveness be lost. Should I drag the packs into the group of elements after cloning a responsive page OR the php pages will remain unresponsive while thr HTML pages will continue to be responsive. Thanks. |
|
Total nerd
|
|
Dmit OE
Admin Group Joined: May 31 2012 Status: Offline Points: 5283 |
Post Options
Thanks(0)
|
There's no impact of the page type to their responsive behavior, a PHPpage just adds a possibility to execute PHP code it contains on opening, the rest remains unchanged. The packs won't break your responsive design, you may just need to style pack elements accordingly.
|
|
tommyshelby
Newbie Joined: Mar 23 2019 Status: Offline Points: 1 |
Post Options
Thanks(0)
|
The database connection error is happening with me as well and the thing is that due to the connection error I am not being able to access the Itunes account as it is connected with the database of mine. I am getting iTunes error 9 while accessing that.
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |