Pixelpost

jeremycherfas · #11 03-10-2005, 02:36 PM

OK. Panic over. I deleted via FTP, rather than deactivating, and the behaviour of the blog is back to normal. Thanks.

But I don't think the plug-in works as intended. At least not for me; it looks good on your blog.

**raminia**+ · #12 03-10-2005, 02:41 PM

strange!
1) tell me which version of wordpress you are running.
2) check your admin/pixelpost.php file and the name of databases. Did you set $pixelpost_db_prefix correctly.

**raminia**+ · #13 03-10-2005, 02:43 PM

what is the prefix of your wordress tables? wp?

**raminia**+ · #14 03-10-2005, 02:56 PM

I think the problem was that I opened a db connection and did not closed it and you may use another addon which does not check which database it is going to connect before executing queries. I added a closing statement to the code and you can download from the same addresss.
Please try it agian check if it OK now.

jeremycherfas · #15 03-10-2005, 02:58 PM

I am still running WP 1.2

The prefix of my all my tables is jcherfas_

I have two databases. jcherfas_photos and the prefix there is pixelpost_

jcherfas_weblog and the prefix there is wp_

Code:

$pixelpost_db_pixelpost = "jcherfas_photos"; // database

The Pixelpost site works fine. The WordPress site works fine. But the plug-in didn't

Thanks for your help in sorting this out. It will be a great and very useful plug-in for me.

**raminia**+ · #16 03-10-2005, 03:01 PM

I'm almost assured that the problem is with multiple DB connection described in http://ir.php.net/manual/en/function.mysql-close.php and with my latest change in the code it should be OK but I'm not confident. Test it please.

jeremycherfas · #17 03-10-2005, 03:11 PM

OK, I just tried again with the latest version.

I no longer get the database errors.

But it still does not work.

The problem seems to be that the HTML output of WP's index.php is truncated immedately before the show_latest_pixelpost_thumbnail line.

Even stranger, I commented out the line, and I still had the problem.

Removing the line completely, and deleting the plug-in via FTP, and everything was back to normal again.

**raminia**+ · #18 03-10-2005, 03:15 PM

houm....
check
1) the pixelpost.php address
2) check if the plugin is deactivated (most probable)
3) check the syntax.

jeremycherfas · #19 03-10-2005, 03:29 PM

Checked all three. Now we are back to the tables not existing errors as described before!

I will download again to make absolutely sure.

Later: downloaded again. Now, the thumbnail is showing, and the link to my photoblog works, but the errors as reported before persist.

Quote:

Database error: [Table 'jcherfas_photos.wp_categories' doesn't exist]
SELECT * FROM wp_categories WHERE 1=1

Database error: [Table 'jcherfas_photos.wp_users' doesn't exist]
SELECT * FROM wp_users WHERE user_level > 0

Database error: [Table 'jcherfas_photos.wp_posts' doesn't exist]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2005-03-10 16:32:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 20

Database error: [Table 'jcherfas_photos.wp_posts' doesn't exist]
SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_date < '2005-03-10 17:32:25' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DE

If it helps, I'm also running the following plug-ins

Search Hilite, Hello Dolly. That's it!

**raminia**+ · #20 03-10-2005, 03:47 PM

ok I'm working on it but I think the problem is somewhere else.
( I found a bug in my codes right now.... )

Pixelpost

Authentic Photoblog Flavour