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 — 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
]]>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 — 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.
]]>I am curious - did the installer throw any errors when first installing? Did the installer properly set up the template directory outlined here: http://www.bigtreecms.org/documentation … templates/? This sounds different then the error Rosie was reporting which stemmed from the MySQL interface.
]]>I am brand new to Big Tree so I'm not quite sure where to start!
Thanks!
]]>Using the mysqli interface is preferred since the old mysql has been deprecated as of PHP 5.5.0 (http://www.php.net/manual/en/intro.mysql.php). If you are running an older version and only have access to the old mysql interface, you can update your config.php file from:
$bigtree["config"]["sql_interface"] = "mysqli";
to:
$bigtree["config"]["sql_interface"] = "mysql";
]]>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
]]>( ! ) 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
]]>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.
]]>