Home •  Forum •  FAQ •  Search •  Recent Topics •  Memberlist •  Register •  Log in 
Forum » Icy Phoenix Support » General Support

SQL ERROR [ Mysql4 ] When I Write In Forum

Reply to topic

Goto page 1, 2  Next

Il Giustiziere
Quote
Posts: 11
Thu 28 Sep, 2017 11:04
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: [Download] [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

Profile PM  
Informpro
Quote
Posts: 1110
Thu 28 Sep, 2017 11:43
Subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Hi,

Did you try to write an empty message?

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

Profile PM  
Informpro
Quote
Posts: 1110
Thu 28 Sep, 2017 15:39
Subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Can you tell us how you got this error message?

Profile PM  
Il Giustiziere
Quote
Posts: 11
Sat 30 Sep, 2017 09:41
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. :(

Profile PM  
Mighty Gorgon
Quote
Posts: 7192 Location: Borgo San Michele
Sun 01 Oct, 2017 12:03
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?

Profile PM   Website
Il Giustiziere
Quote
Posts: 11
Fri 13 Oct, 2017 15:13
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?

Last edited by Il Giustiziere on Tue 17 Oct, 2017 11:24; edited 1 time in total
Profile PM  
Il Giustiziere
Quote
Posts: 11
Sun 15 Oct, 2017 16:24
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?

Profile PM  
Informpro
Quote
Posts: 1110
Thu 19 Oct, 2017 10:46
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.

Profile PM  
Il Giustiziere
Quote
Posts: 11
Thu 19 Oct, 2017 15:53
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

Profile PM  
Informpro
Quote
Posts: 1110
Tue 24 Oct, 2017 15:25
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?

Profile PM  
Il Giustiziere
Quote
Posts: 11
Thu 26 Oct, 2017 15:59
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?

Profile PM  
Informpro
Quote
Posts: 1110
Thu 26 Oct, 2017 17:58
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?

Profile PM  
Il Giustiziere
Quote
Posts: 11
Fri 27 Oct, 2017 08:57
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 ]

Profile PM  
Mighty Gorgon
Quote
Posts: 7192 Location: Borgo San Michele
Sat 04 Nov, 2017 10:34
Subject: Re: SQL ERROR [ Mysql4 ] When I Write In Forum
Hi, did you fix it?

Did you try to contact server support?

Profile PM   Website
Reply to topic
Goto page 1, 2  Next

Page 1 of 2


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.1047s (PHP: 22% SQL: 78%)
SQL queries: 12 - Debug Off - GZIP Enabled