Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 2
Goto page 1, 2  Next
 
Reply with quote Download Post 
Post 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
 



 
Il GiustiziereSend private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: SQL ERROR [ Mysql4 ] When I Write In Forum 
 
Hi,

Did you try to write an empty message?
 




____________
IcyPhoenix ADR RPGEzArena (modded phpBB2+ADR)
 
InformproSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: SQL ERROR [ Mysql4 ] When I Write In Forum 
 
If I do it, open windows:
"you must insert text to enter message"
 



 
Il GiustiziereSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: SQL ERROR [ Mysql4 ] When I Write In Forum 
 
Can you tell us how you got this error message?
 




____________
IcyPhoenix ADR RPGEzArena (modded phpBB2+ADR)
 
InformproSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 



 
Il GiustiziereSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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?
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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 
Il GiustiziereSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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?

 



 
Il GiustiziereSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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.
 




____________
IcyPhoenix ADR RPGEzArena (modded phpBB2+ADR)
 
InformproSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 



 
Il GiustiziereSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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?
 




____________
IcyPhoenix ADR RPGEzArena (modded phpBB2+ADR)
 
InformproSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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?
 



 
Il GiustiziereSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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?
 




____________
IcyPhoenix ADR RPGEzArena (modded phpBB2+ADR)
 
InformproSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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 ]

 



 
Il GiustiziereSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: SQL ERROR [ Mysql4 ] When I Write In Forum 
 
Hi, did you fix it?

Did you try to contact server support?
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 2
Goto page 1, 2  Next


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




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


  

 

  cron