Installation Issue

13 posts / 0 new
Last post
support
support's picture
Installation Issue

(This question was ported from a Direct Mail by a purchaser)

Just downloaded Scencillo template but it won't load. Getting this error message:
Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sen.semaphore' doesn't exist: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 17460937444f96c42733d733.26570961 ) in lock_release_all() (line 269 of C:\xampp\htdocs\sen\includes\lock.inc).
Uncaught exception thrown in session handler.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sen.sessions' doesn't exist: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ) FOR UPDATE; Array ( [:db_condition_placeholder_0] => aWnU8hUaf1wlmpSOv2RK6t1TXaJSCUBl87aeDYb7t4 [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 206 of C:\xampp\htdocs\sen\includes\session.inc).

support
support's picture
Thanks a lot for purchasing

Thanks a lot for purchasing Sencillo. I'm the creator of it, so I'll be pleasure to support you.

The error you have is a database server configuration issue that launched an error during Sencillo installation process. Try following tasks to solve it. I recommend you to do it one by one and each time you do, clean your database and start a new install. I would also appreciate you let me know wich worked for you in case one did. If not, let me know and we'll keep going through to solve it.

Possible Solution 1 - Enable PDO MySQL extension for PHP.

I see you're using Xamp. So, on your php.ini file, search for the following string:

;extension=php_pdo_mysql.dll"

and remove the comment ";" so it stays:

extension=php_pdo_mysql.dll

Then remove your Apache Server

2 - Possible Solution 2 - Increase your server memory limit:

On the same php.ini file, search for the string: "max_execution_time". tere you'll find 3 parameters. I recommend you to increase them to fit this sample values:

max_execution_time = 560 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 256M ; Maximum amount of memory a script may consume (8MB)

It will allow your local server to run more easy and faster. Perhaps the SQL import process was cut down during the installation process. Restar Apache at the end.

That's all. Please let me know if it works for you.

support
support's picture
Thanks for your prompt

Thanks for your prompt response and it was Solution 2 that solved the issue.

All working fine now.

prashant
prashant's picture
Suggestion

Hello Support,
Even I had same problem but I have resolved this now.
Just a suggestion for this problem, if you add the following run-time php settings in your script for installing DB. It will resolve the problem for many peoples who are not running PHP in safe mode.

ini_set('max_execution_time', 560);
ini_set('max_input_time', 60);
ini_set('memory_limit', 256);

Thanks

support
support's picture
Thanks Prashant!

Thanks Prashant!

We will add it.

davereplicant
davereplicant's picture
Same Here,

Same Here,

Tried both these suggestions. My PHP settings for time etc.. were way above spec to start with but I'm not seeing extension=php_pdo_mysql.dll in my PHP.ini file so I added the line if the PDO area of the file - see below

"[Pdo]
; Whether to pool ODBC connections. Can be one of "strict", "relaxed" or "off"
; http://www.php.net/manual/en/ref.pdo-odbc.php#ini.pdo-odbc.connection-po...
;pdo_odbc.connection_pooling=strict
extension=php_pdo_mysql.dll"

- (restarted http) to no avail.

ALSO..

'prefix' => '', is in my site settings.php

Here's my error...

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'frankusherdb.variable' doesn't exist
Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'frankusherdb.semaphore' doesn't exist: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 14785477245404c2481d71c9.94476660 ) in lock_release_all() (line 269 of /var/www/vhosts/frankusherguitars.co.uk/httpdocs/test/includes/lock.inc).

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'frankusherdb.sessions' doesn't exist: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_condition_placeholder_0] => 1Dkgc2CPfzQtxTqv1KXvhBD9-bTmaDQcaI8jUzXmTk8 [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of /var/www/vhosts/frankusherguitars.co.uk/httpdocs/test/includes/session.inc).

support
support's picture
Hi Dave:

Hi Dave:

Already sent you the fix. :)

Best!

nick.e
nick.e's picture
Install not working for me as well!

I am getting error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'WhiteheadSigns.variable' doesn't exist

Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'WhiteheadSigns.semaphore' doesn't exist: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 158641014454199804d00c70.26310442 ) in lock_release_all() (line 269 of /var/www/SandBox/WhiteheadSigns.com/MainSite/includes/lock.inc).

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'WhiteheadSigns.sessions' doesn't exist: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_condition_placeholder_0] => JHKYmRQ2zQrnGIv9t04xOJ4TOHu-V9CqfUSB3L6qoFI [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of /var/www/SandBox/WhiteheadSigns.com/MainSite/includes/session.inc).

Cleared DB every time, reset files every time - tried restarting apache, changing php limits.
Server runs 5 other drupal sites.

I've set PHP limits to:
Max Memory: 512
Execution 900
Input -1 (unlimited - was originally 60)

PDO is enabled in my php core I believe as info.php shows:
PDO

PDO support enabled
PDO drivers mysql

pdo_mysql

PDO Driver for MySQL enabled
Client API version 5.1.73

The error above occurs at the "configure site" step of the drupal install.

I've spent a couple hours trying different things to get this to behave but no luck. Please help. :)

Server is Debian Wheezy Running PHP 5.3.3-7 and Apache and as mentioned several other drupal sites are working on this server.

Thank you.

support
support's picture
Hi there Nick.e:

Hi there Nick.e:

Seems your problem is with table prefixes. I see in the error you used "WhiteheadSigns"

To fix it, please read this post: http://doublemthemes.com/forum/do-not-use-database-prefixes-youre-loadin...

Best!!!

croy
croy's picture
Base table or view not found

So I downloaded just last week, and am getting this error:

Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'croy_sencillo.semaphore' doesn't exist: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 902764134542c78dc149919.19677359 ) in lock_release_all() (line 269 of /home/croy/public_html/sencillo/Theme Files/includes/lock.inc).

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'croy_sencillo.sessions' doesn't exist: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_condition_placeholder_0] => sVLnfOku9Ac9_bfsTiYAdA5ZpbAys-gyzvuunUFgnrM [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of /home/croy/public_html/sencillo/Theme Files/includes/session.inc).

Assistance appreciated, thanks!
-Carrie

support
support's picture
Hi there Croy:

Hi there Croy:

The DB script is broken in the package. We are uploading it again with the fixed script.

Best!!

croy
croy's picture
still not available

Hi, themesnap does not appear to have the updated file (I'm getting the same error and the dates show no updates to their current downloadable file). Could you please send it to me?

support
support's picture
Hi there Croy:

Hi there Croy:

It is already updated at ThemeSnap.com You can redownload it.

Best!!!

Log in to post comments