Meta Categories Browser

[ego-s]

I totally missed the part where it says : not only open index.php after switching on error reporting but also test the category plugin ( ... i'm a noob, i know )

error for most and last : Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mywebsite/../meta_categories.php on line 120

errors for clouds : Warning: Wrong parameter count for max() in /mywebsite/../meta_categories.php on line 174

Warning: Wrong parameter count for min() in /mywebsite/../meta_categories.php on line 174

Warning: Invalid argument supplied for foreach() in /mywebsite/../meta_categories.php on line 179

thx in advance

[ego-s]

Any clues so far? I'd love this plug to run.
Do you think it depends on the sql version?

[se.nsuo.us]

Oops! forgot about this - sorry - yes looks like your MySQL is not supporting the REPLACE INTO query to be exact

PHP Code:

$query = "REPLACE INTO {$pixelpost_db_prefix}views(parent_id,ip,this_month) VALUES ('$image_id', '{$_SERVER['REMOTE_ADDR']}',$this_month)"; 


This query is not getting executed - can you have your MySQL upgraded and try again?

[ego-s]

it's working
I didn't want to upgrade at first, because I cannot go back to the previous version (without reinstalling) ... so, you know this "never change a running ..."

but hey ... it's working

thx!

[iphimeda]

Nice. I like the idea. Going to test it on my photoblog next week. =)

[Ubbe]

hey i'm having same problem as ego, what do you mean by upgrading mysql??

[ego-s]

I was able to upgrade the mysql-Version in use by my Pixelpost installation via the admin interface of my webspace. I changed from 3.23.58 to 4.1.14 and it's working now ( http://ego-s.net/pixel/index.php?x=meta&z=lastviewed ).

So it all depends on your hoster

[Ubbe]

my db currently runs on 4.0.24 and i can't upgrade it so this means i can not use the meta tags "last viewed" & "most viewed"?

[GeoS+]

In MySQL manual there is info that REPLACE statement can be replaced with INSERT ... ON DUPLICATE KEY UPDATE which is available as of MySQL 4.1.0 :/

http://dev.mysql.com/doc/refman/4.1/en/replace.html

[Ubbe]

Thanks for the link GeoS, i looked on it, but i simply can't find out what exactly to do, is there any chance you could like "cut it out" for me.? hehe