Installing / create tables get Error: Too big precision 14

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

<<< 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

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. I had to change the value as the most it will accept it said was 6.

Kate hope this helps

please i have the same issue please send me configure install.php file and send me please lol4lifehehe@gmail.com

How many times has this issue been asked and answered?
See the two replies by Tec and Kated on this very page.