Incorrect integer value

Databases
1

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)

2

what’s in row 1?

3

@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

4

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

5

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

6

can’t help you, sorry

if you post the actual database statement, maybe

otherwise, you’re looking for a different forum

7

@r937

No problem. Thank you

8

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