#1 Re: General » Sql.php errors after installation » March 11, 2013 4:26am

Cheers. I did have the host name wrong in config.php but now I'm getting the following. However I checked the settings and the database name is correct and all the tables created successfully on the server:


Fatal error: Uncaught exception 'Exception' with message 'sqlfetch() called on invalid query resource. The most likely cause is an invalid sqlquery() call. Last error returned was: <b>No database selected</b> in query &mdash; SELECT * FROM bigtree_modules' in /home/roseschi/public_html/core/inc/bigtree/sql.php:290 Stack trace: #0 /home/roseschi/public_html/core/inc/bigtree/cms.php(24): sqlfetch(false) #1 /home/roseschi/public_html/core/bootstrap.php(50): BigTreeCMS->__construct() #2 /home/roseschi/public_html/core/admin/router.php(256): include('/home/roseschi/...') #3 /home/roseschi/public_html/site/index.php(55): include('/home/roseschi/...') #4 {main} thrown in /home/roseschi/public_html/core/inc/bigtree/sql.php on line 290

#2 Re: General » Sql.php errors after installation » March 9, 2013 7:56pm

Hi again,


I've recently put a copy on my web hosting which doesn't have mysqli - just mysql php interface. I changed the setting in config.php in the templates folder however I'm getting these errors:


Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'roseschi'@'27.124.120.41' (using password: YES) in /home/roseschi/public_html/core/inc/bigtree/sql.php on line 176

Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /home/roseschi/public_html/core/inc/bigtree/sql.php on line 177

Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/roseschi/public_html/core/inc/bigtree/sql.php on line 178

Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/roseschi/public_html/core/inc/bigtree/sql.php on line 258

Fatal error: Uncaught exception 'Exception' with message 'sqlfetch() called on invalid query resource. The most likely cause is an invalid sqlquery() call. Last error returned was: <b>Access denied for user 'roseschi'@'27.124.120.41' (using password: YES)</b> in query &mdash; SELECT * FROM bigtree_modules' in /home/roseschi/public_html/core/inc/bigtree/sql.php:290 Stack trace: #0 /home/roseschi/public_html/core/inc/bigtree/cms.php(24): sqlfetch(false) #1 /home/roseschi/public_html/core/bootstrap.php(50): BigTreeCMS->__construct() #2 /home/roseschi/public_html/site/index.php(89): include('/home/roseschi/...') #3 {main} thrown in /home/roseschi/public_html/core/inc/bigtree/sql.php on line 290


Not sure what the next step is.


Thank you.

#3 Re: General » Sql.php errors after installation » February 27, 2013 8:02pm

Fixed!


I installed the wamp server in this post: http://www.bigtreecms.org/discussion/di … ws-wamp/p1


You also need to enable php_curl on the wamp server plus any settings listed in above post


Note: I found 2 php.ini files so make sure you have edited all the settings the install.php page tells you

#4 Re: General » Sql.php errors after installation » February 27, 2013 7:50pm

Update: I reinstalled wamp and now I'm getting:


( ! ) Fatal error: Uncaught exception 'Exception' with message 'Google PHP API Client requires the CURL PHP extension' in C:\wamp\www\test\core\inc\lib\google\apiClient.php on line 20( ! ) Exception: Google PHP API Client requires the CURL PHP extension in C:\wamp\www\test\core\inc\lib\google\apiClient.php on line 20

#5 General » Sql.php errors after installation » February 27, 2013 4:52am

rosie11
Replies: 9

Hi,


I'm new to Big Tree CMS. I've justed installed a copy locally on a WAMP stack. The install.php seemed to work but I'm getting the following errors when I navigate to localhost/site:


Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\core\inc\bigtree\sql.php on line 14

Warning: mysqli::query(): Couldn't fetch mysqli in C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\core\inc\bigtree\sql.php on line 15

Warning: mysqli::query(): Couldn't fetch mysqli in C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\core\inc\bigtree\sql.php on line 94

Warning: sqlquery(): Couldn't fetch mysqli in C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\core\inc\bigtree\sql.php on line 95

Fatal error: Call to a member function fetch_assoc() on a non-object in C:\BitNami\wampstack-5.4.11-0\apache2\htdocs\core\inc\bigtree\sql.php on line 129


Do I need to adjust database permissions? Any help would be greatly appreciated.


Thanks.

Board footer

Powered by FluxBB

The Discussion Forum is not available on displays of this size.