Installing / create tables get Error: Too big precision 14
September 02, 2016 01:03AM
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 12:39PM
<<< 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 11: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
Re: Installing / create tables get Error: Too big precision 14
February 17, 2018 11:03AM
please i have the same issue please send me configure install.php file and send me please lol4lifehehe@gmail.com
rap
Re: Installing / create tables get Error: Too big precision 14
February 17, 2018 05:48PM
How many times has this issue been asked and answered?
See the two replies by Tec and Kated on this very page.
Sorry, only registered users may post in this forum.

Click here to login