Support community for TTG plugins and products.
NOTICE
The Turning Gate's Community has moved to a new home, at https://discourse.theturninggate.net.
This forum is now closed, and exists here as a read-only archive.
You are not logged in.
Pages: 1
Tried to update an album via publisher and got an error message:
"...internal error has occurred: JSON.lua:498: JSON.lua:197: can't parse JSON at char 1 of: Unable to find the SQLite Module..."
So...what do i do now?
Offline
Rod
Just a user with way too much time on his hands.
www.rodbarbee.com
ttg-tips.com, Backlight 2/3 test site
Offline
So updates will solve this? I just assumed something was up with the server since there wasn't a problem last time I updated a gallery (2 weeks ago). In that time I have been redoing my website so I'm wondering if there could be a conflict there.
Offline
updated could solve it. But the rest of the page directs you to post links, etc. (including sending logs to Ben)
Rod
Just a user with way too much time on his hands.
www.rodbarbee.com
ttg-tips.com, Backlight 2/3 test site
Offline
Hi. As the message implies, the SQLite module could not be found. I suggest you contact your host's technical support and request that they enable (or re-enable, as seems to be the case) the SQLite and SQLite PDO modules.
Offline
Hi guys, so i finally heard back from my host's technical support and they indicated that both SQLite and PDO modules are installed and enabled on the server. So i'm not really sure where to go from here. It's still not working and things are backing up. Any ideas?
Thanks,
Steve
Offline
have you sent the logs to Ben?
Rod
Just a user with way too much time on his hands.
www.rodbarbee.com
ttg-tips.com, Backlight 2/3 test site
Offline
Yes. Last week. I'm assuming he looked at them prior to responding here, but i'm not sure.
Offline
I didn't make the connection between your email and this topic, sorry. However, the logs aren't actually helpful in this case.
Can you create a PHP file and upload it to your public_html directory with the following contents:
<?php
$availableDrivers = PDO::getAvailableDrivers();
echo '<p>Available PDO drivers: <pre>'.print_r($availableDrivers, true).'</pre></p>';
if (in_array('sqlite', $availableDrivers)) {
echo '<p>sqlite PDO driver is available</p>';
} else {
echo '<p>sqlite PDO driver is <strong>NOT</strong> available</p>';
}
?>This is the same logic used used by Backlight in determining availability of the necessary SQLite modules.
Once uploaded, open the file in your browser and let us know what the output is. If sqlite is not listed and marked as not available, then I suggest providing the link to your host's support.
Offline
Hi Ben, thanks for that. They ensure me both modules are working. I just got off the phone with support. So before i do what you are suggesting, I'm going to email you their suggestions which they want me to pass on to you. Maybe you can make some sense of it. Thanks. Hope to get this working soon because I totally rely on your product!
Offline
Thanks for the email. Look under the PDO Drivers section on the PHP Info link they provided: it's empty ('no value').
It should have several entries, especially sqlite. On my hosting, I have the following listed: dblib, mysql, odbc, pgsql, sqlite
Offline
Further from my last post. Your PHP Info has no sections for pdo_sqlite or sqlite3. The modules are NOT setup and running correctly.
Offline
So i shared what you mentioned with the site5 support. I didn't hear anything from them. Just checked now and it's working. And I see that what you mentioned as being missing is now there. I wish I'd now what happened in the last couple of weeks, but it's wrong now and that's the most important part.
Once again, thanks so much for your support Ben! You pointed the support team at the host provider in the right direction with specifics. Awesome!
With thanks,
Steve
Offline
Hi Steve, I'm glad that it's solved now and to have been able to help.
Your PHP Info is looking much better!
Offline
Hi Ben, so I think i might have spoken too soon. Not about the thanks, of course, but that everything was working. The TTG-BE works now, but when I try to enter a client gallery, i get the same message as previous about the modules not enabled. So frustrating!
Offline
That's odd. Can you provide a link to one of the galleries showing the error?
Offline
try clearing browser cache too
Rod
Just a user with way too much time on his hands.
www.rodbarbee.com
ttg-tips.com, Backlight 2/3 test site
Offline
Hi Ben, I'll send you an email with some links in different folders.
Offline
Thanks Ben, you fixed it! Gave Ben access to the ftp and he did what the support team at my host provider couldn't. Awesome support!
Last edited by eveall (2016-11-17 21:15:12)
Offline
Pages: 1