Icy Phoenix

     
 

Home » Forum » Icy Phoenix Support » General Support

The time now is Thu 18 Apr, 2024 20:11 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Disable KB mode Download Topic Printable Version Email to a Friend View next topic

SQL ERROR [ Mysql4 ] When I Write In Forum

SQL ERROR [ Mysql4 ] When I Write In Forum

Article
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 Giustiziere - View user's profile Send private message  
Il Giustiziere [ Thu 28 Sep, 2017 11:04 ]
Sponsors
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us


SQL ERROR [ Mysql4 ] When I Write In Forum

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

Did you try to write an empty message?



 
Informpro - View user's profile Send private message  
Informpro [ Thu 28 Sep, 2017 11:43 ]
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 Giustiziere - View user's profile Send private message  
Il Giustiziere [ Thu 28 Sep, 2017 11:47 ]
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?



 
Informpro - View user's profile Send private message  
Informpro [ Thu 28 Sep, 2017 15:39 ]
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 Giustiziere - View user's profile Send private message  
Il Giustiziere [ Sat 30 Sep, 2017 09:41 ]
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?



 
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Sun 01 Oct, 2017 12:03 ]
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 Giustiziere - View user's profile Send private message  
Il Giustiziere [ Fri 13 Oct, 2017 15:13 ]
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 Giustiziere - View user's profile Send private message  
Il Giustiziere [ Sun 15 Oct, 2017 16:24 ]
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.



 
Informpro - View user's profile Send private message  
Informpro [ Thu 19 Oct, 2017 10:46 ]
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 Giustiziere - View user's profile Send private message  
Il Giustiziere [ Thu 19 Oct, 2017 15:53 ]
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?



 
Informpro - View user's profile Send private message  
Informpro [ Tue 24 Oct, 2017 15:25 ]
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 Giustiziere - View user's profile Send private message  
Il Giustiziere [ Thu 26 Oct, 2017 15:59 ]
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?



 
Informpro - View user's profile Send private message  
Informpro [ Thu 26 Oct, 2017 17:58 ]
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 Giustiziere - View user's profile Send private message  
Il Giustiziere [ Fri 27 Oct, 2017 08:57 ]
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?



 
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Sat 04 Nov, 2017 10:34 ]
Display posts from previous:    

HideWas this topic useful?

Post new topic  Reply to topic  Page 1 of 2
Goto page 1, 2  Next
 

Home » Forum » Icy Phoenix Support » General Support

The time now is Thu 18 Apr, 2024 20:11 • All times are UTC + 1 Hour [DST enabled]
View previous topic Recent Topics Disable KB mode Download Topic Printable Version Email to a Friend View next topic




 


 
 Powered by Icy Phoenix based on phpBB
Lo-Fi Version - Privacy Policy - Cookie Policy
Generation Time: 0.2353s (PHP: 11% SQL: 89%)
SQL queries: 12 - Debug Off - GZIP Enabled
Design by Luca Libralato 
  cron