Welcome! Log In Create A New Profile

Advanced

Installing / create tables get Error: Too big precision 14

Posted by weasy 
Installing / create tables get Error: Too big precision 14
September 01, 2016 10:03PM
Hello,

http://blah.com/sphider/admin/install.php
When I try to install and create the tables I get this error:

Sphider installation script.
Error: Too big precision 14 specified for 'time'. Maximum is 6.
Creating tables failed. Consult the above error messages.

Any idea why this would happen and if there is a work around?

My mysql version if it's important.
Server version: 5.5.44-MariaDB-log MariaDB Server


Jim
Tec
Re: Installing / create tables get Error: Too big precision 14
September 02, 2016 09:39AM
<<< My mysql version if it's important.
Server version: 5.5.44-MariaDB-log MariaDB Server >>>

Yes, it is important. Because the original Sphider does not work with MySQL 5.5+
Developed about 10 years ago, and unsupported since 8 years, the original Sphider does not contain the mysqli database connector, which is obligatory for MySQL v.5.5+

Use the improved version of Sphider, which was developed by 'rap', or use Sphider-plus.

Tec
Re: Installing / create tables get Error: Too big precision 14
June 15, 2017 08:07AM
Hi I had the same error on installing my copy.

I changed the value from 14 to 6 in the install.php in the tables. I can now get into admin but now I'm stuck on how to include the php on the search,php page.

just change it in the install.php file and it shuld work for you. smiling smiley I had to change the value as the most it will accept it said was 6.

Kate smiling smiley hope this helps
Sorry, only registered users may post in this forum.

Click here to login