SQL ERROR [ Mysql4 ] When I Write In Forum »  Show posts from    to     

Icy Phoenix


General Support - SQL ERROR [ Mysql4 ] When I Write In Forum



Il Giustiziere [ Thu 28 Sep, 2017 11:04 ]
Post subject: SQL ERROR [ Mysql4 ] When I Write In Forum
Hi, if I try to write a post in forum it give me following error:

Code: [Hide] [Select]
Notice: in ....... /includes/db/mysql.php on line 906

Notice:
SQL ERROR [ mysql4 ]

Incorrect integer value: '' for column 'log_target' at row 1 [1366]

SQL

INSERT INTO ip_logs (log_id, log_time, log_page, log_user_id, log_action, log_desc, log_target) VALUES ('25498', '1504535506', 'posting.php', '2', 'MESSAGE', '203', '')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()

FILE: includes/functions_mg_log.php
LINE: 104
CALL: sql_db->sql_query()

FILE: includes/functions.php
LINE: 6260
CALL: ip_log()

FILE: includes/functions.php
LINE: 5977
CALL: message_die()

FILE:
LINE:
CALL: msg_handler()

FILE: includes/db/mysql.php
LINE: 909
CALL: trigger_error()

< in ..... /includes/db/mysql.php on line 909
Informazione Critica
SQL ERROR [ mysql4 ]

Field 'post_text_compiled' doesn't have a default value [1364]

SQL

INSERT INTO ip_posts (topic_id, forum_id, poster_id, post_username, post_subject, post_text, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_autolinks_acronyms, enable_sig) VALUES (4412, 7, 2, '', 'prova', 'dfsdfsfds f fgfg', 1504535506, '151.54.34.165', 1, 1, 1, 1, 1)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 295
CALL: sql_db->sql_error()

FILE: includes/functions_post.php
LINE: 486
CALL: sql_db->sql_query()

FILE: posting.php
LINE: 1307
CALL: submit_post()


Please halp me. My version is 2.0.0.86
php version 5.3.10
mysql version 5.6.33-log

thank you


Informpro [ Thu 28 Sep, 2017 11:43 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Hi,

Did you try to write an empty message?


Il Giustiziere [ Thu 28 Sep, 2017 11:47 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
If I do it, open windows:
"you must insert text to enter message"


Informpro [ Thu 28 Sep, 2017 15:39 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Can you tell us how you got this error message?


Il Giustiziere [ Sat 30 Sep, 2017 09:41 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Informpro wrote: [View Post]
Can you tell us how you got this error message?


everytime I write a message in the forum.

It's impossible to write in the forum.


Mighty Gorgon [ Sun 01 Oct, 2017 12:03 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
That's very strange, try to disable LOGGING in ACP...

Can you update to latest stable Icy Phoenix version? Or at least install it on your server just to make a test?


Il Giustiziere [ Fri 13 Oct, 2017 15:13 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Mighty Gorgon wrote: [View Post]
That's very strange, try to disable LOGGING in ACP...

Can you update to latest stable Icy Phoenix version? Or at least install it on your server just to make a test?


I've tried to di it, but I get many errors.

I've installed on local (my pc with wamp server) and it works fine!

can errors depend by server altervista?


Il Giustiziere [ Sun 15 Oct, 2017 16:24 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Il Giustiziere wrote: [View Post]
Mighty Gorgon wrote: [View Post]
That's very strange, try to disable LOGGING in ACP...

Can you update to latest stable Icy Phoenix version? Or at least install it on your server just to make a test?


I've tried to di it, but I get many errors.

I've installed on local (my pc with wamp server) and it works fine!

can errors depend by server altervista?


Informpro [ Thu 19 Oct, 2017 10:46 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Hi,

Maybe it's because of a server error. Do you know what version of MySQL Altervista is running? That can help us.


Il Giustiziere [ Thu 19 Oct, 2017 15:53 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Informpro wrote: [View Post]
Hi,

Maybe it's because of a server error. Do you know what version of MySQL Altervista is running? That can help us.


Altervista run

Operating system: Linux ()
MySQL-Version: 5.6.33-log
PHP-Version: 5.3.10


Informpro [ Tue 24 Oct, 2017 15:25 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
How long have you been having this error?
Did you change configuration?

Do you maybe know if Altavista has MySQL strict mode enabled?


Il Giustiziere [ Thu 26 Oct, 2017 15:59 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Informpro wrote: [View Post]
How long have you been having this error?
Did you change configuration?

Do you maybe know if Altavista has MySQL strict mode enabled?


I Don't know. How do I see that?


Informpro [ Thu 26 Oct, 2017 17:58 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
I am not sure it is easy to check. Do you have access to the server, or only FTP?


Il Giustiziere [ Fri 27 Oct, 2017 08:57 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Informpro wrote: [View Post]
I am not sure it is easy to check. Do you have access to the server, or only FTP?


I have only ftp, and I can olny modify php.ini.

I've installed Mysqldumer, and I looked in the middle mysql variables. I Think the Strict Mode variable is this:

sql_mode STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION

is there a way to modify it with mysqldumper?
I attach below all the SQL variables:
Spoiler: [ Show ]


Mighty Gorgon [ Sat 04 Nov, 2017 10:34 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Hi, did you fix it?

Did you try to contact server support?


Il Giustiziere [ Sat 04 Nov, 2017 11:43 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Mighty Gorgon wrote: [View Post]
Hi, did you fix it?

Did you try to contact server support?


No, they don't support.


Mighty Gorgon [ Sat 04 Nov, 2017 11:47 ]
Post subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
You may try to fix single errors to see what happens... but if they enabled STRICT mode, you may have other issues.

I'll write you privately.




Powered by Icy Phoenix