Incorrect integer value

Everything works on one server but when I install on Godaddy I get this error:

Incorrect integer value: ‘’ for column ‘rotator_id’ at row 1

Why do I get this error on one server and not the other?

Thanks

Godaddy:
Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.6.30-cll-lve - MySQL Community Server (GPL)
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)

Other Server:
Server: Localhost via UNIX socket
Server type: Percona Server
Server version: 5.5.52-38.3 - Percona Server (GPL), Release 38.3, Revision 109ad68
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)

what’s in row 1?

@r937

I don’t know what’s in row 1

These errors happen in different areas. This is just one of them.

Look like it should work both have php 5.6

but that looks like a database error, not a php error

but lo and behold, you are running ~different~ database servers

so it’s no surprise a database statement will work in one and not the other

@r937

That’s what I was kind of thinking. It looks like it should work on the Godaddy server better as it seems more standard.

Can I connect the scripts from Godaddy to use the other database?

I’m just trying to fix the problem some way.

can’t help you, sorry

if you post the actual database statement, maybe

otherwise, you’re looking for a different forum

@r937

No problem. Thank you

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.