POPfetcher Error

[GraveDigger]

Hi All,

Solved 99% of my "problems" with this software by myself (reading manuals, this forum and google

I have a working installation on my XP sandbox - everything except the popfetcher plugin.

MESSAGE PART -- Found attachment named: blinzelbazille.gif
Wrote attachment into file named: blinzelbazille.gif
Published new blog entry with id:

INSERT INTO serendipity_entries (isdraft,title,body,authorid,allow_comments,moderate_comments,extended,timestamp,exflag,comments,last_modified,author) values ('false', 'Test', '\"Click', '2', '1', '', '', '1192125086', '0', '0', '1192125086', 'admin')

/ Data truncated for column 'moderate_comments' at row

is the error I get when I manually run popfetcher from the admin interface... - the picture (blinzelbazille.gif) gets created in the media folder - but the entry in the db seems to fail. Tried it from various mail-accounts with various settings... no success.

the error must be in the insert statement.... probably, as I can't run it as it is posted above.... mysql mentions the '' are wrong.... point is only that I do not have a clue what mysql wants ( " or ' or nothing

thanks for any help

.GraveD

I'm using all the latest versions (mysql, php, apache, s9y, popfetcher)

any ideas

[garvinhicking]

Hi!

Which database version exactly are you using? MySQL 5.0.45? And which MySQL PHP extension do you use, mysqli or mysql? And which client library?

It seems the SQL query chokes on an empty "moderate_comments" setting. Usually on the serendipity_entries database table, there should be a "NOT NULL default 'true'" setting for that one, so that it automatically inserts "true" when an empty string is submitted?!

Regards,
Garvin

[GraveDigger]

I use:

PHP : php-5.2.4 & php_mysql.dll

MySQL : 5.0.45

Client Library ? do you mean POPFetcher ? 1.19

on the table itself : the field moderate_comments has the following properties:
Null : No
Default : true

-> the existing entries all are false there.....

need more infos ?

.R

[garvinhicking]

Hi!

Quite strange. Will investigate this.

How did you set the s9y global configuration item "Default: Moderate Comments"? To Yes or No?

Regards,Garvin

[GraveDigger]

general admin:
for both users:
Comments & trackbacks to this entry requires moderation : No

If I adapt the insert statement to give a value for the "moderate_comments" (either 1,0 or true) it accepts the statement..... blank doesn't work either....

Plugin:
If I now set the within the plugin :

Comments & trackbacks to this entry requires moderation : Yes

it works - If I put it back to No - I does not.

My personal assumption is:
a) the MySql parts not working correctly (by not changing a NULL to a default)

b) the plugin sends on NO a NULL instead of a value

.Ralph

[garvinhicking]

Hi!

This is really strange. On my mysql installation (5.0.45 as well) it all works without an error. Do you have customized your my.cnf file, maybe for some strict SQL rules, or some other special options?

You should ask the MySQL forum which MySQL server settings can have an influence on this. I could fix the popfetcher thing to use a non-empty statement. But other s9y plugins and core functions rely on the DEFAULT-behaviour, so we would only fix one thing and leave others.

The proper way would be to check why your MYSQL-server is behaving like this, and toggling that option to the usual setting.

Best regards,
Garvin

[GraveDigger]

I'll play around with the mysql db a little bit more (almost feel at home there - as I'm coming from the Oracle DB world

pretty much everything is default - except that I'm only allowing local use of the db (for security reasons)

I'll try some more stuff over the next weekend and let you know....

thnks for the support !!!!!!!!!!!!!

.Ralph