Addons just don't show

[newandtrying]

Hi !
I've just installed Pixelpost v1.7 on a second site I have (I had installed version 1.6 a few weeks ago on another site). The installation went OK but the addons page is blank. The possibility to use or not the calendar appears in the options page, but for example, I can find no trace of copy_folder, which is an addon I really find useful.
How come none of the addons included by default show ? I have checked the addons folder and it seems fine.
Did I overlook something ?
Thanks for any hints.

[newandtrying]

Now, I have uploaded v1.7.1 after noticing security update.

Addons still don't show. Perusing through the posts, I chanced upon this way to get information :

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/140/sdb/5/1/nouerdesfils/pixelpost/includes/functions.php on line 629

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/140/sdb/5/1/nouerdesfils/pixelpost/includes/functions.php on line 722

What could be missing on those lines ? What does it mean ?
Thanks for your help

[Dkozikowski]

You most likely have an incompatible addon installed.

http://www.pixelpost.org/forum/showthread.php?t=7708

[newandtrying]

I installed v1.7 on a site with no previous installation of Pixelpoint and no additional addons. Then I deleted the SQL base and reinstalled v1.7.1. Addons still did not show. Then I uploaded the Automatic Dynamic Resize addon and it does not show either. I suppose I could not have an incompatible addon since with the two initial installations, the addons page kept blank and still is.
What does the error message mean ?
Any hints ?
Thanks for your patience.

[Birdwalker]

I installed v1.7 on a site with no previous installation of Pixelpoint and no additional addons. Then I deleted the SQL base and reinstalled v1.7.1. Addons still did not show. Then I uploaded the Automatic Dynamic Resize addon and it does not show either. I suppose I could not have an incompatible addon since with the two initial installations, the addons page kept blank and still is.
What does the error message mean ?
Any hints ?
Thanks for your patience.
Hi!
I'm having the same problem. Addons were visible in v1.7R_CI. When I upgraded to v1.7_FINAL, the addons were not visible. I just upgrade to v1.7.1 and the addons are still not visible. I downloaded the Defesnio and Akismet and re-uploaded them to the addons folder and still noting shows in my Addons. Hope someone can help.
Cheers
rb

[newandtrying]

Thanks for your support !
And we're crying HELP !! HELP !! HELP!!

[Dkozikowski]

Can I have access to one of your admin panels? You can PM me the temporary login credentials.

[austriaka]

please open the addons page with adding &errors at the end of the address:
http://yourdomain.com/(pixelpostfolder/)admin/index.php?view=addons&errors

and tell us the error message which comes up then

[Dkozikowski]

Sorry, i forgot to update this thread. Both issues have been "resolved".

In Birdwalker's case, the defensio addon was causing the problem.

As for newandtrying, he uses the free.fr hosting provider which I've decided not to support. There has been many issues with Pixelpost users with this hosting provider and this is due to the limitations they impose on there free hosting accounts. One such example is not allowing the CHMOD command. Files and folders are stuck with 0700 file permissions.

[Dkozikowski]

After some more pleading by newandtrying ;) , I took another look at his pixelpost install and found it to be a MYSQL problem rather than anything else.

His MYSQL database was rejecting the "SHOW TABLE STATUS" command located within the includes/functions.php

[yvette]

I have the same problem. My addon page is blank as well. I did have the defensio addon but removed it. Any ideas how to help me?

The error message I'm getting is:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/blog/addons/paged_archive.php on line 637

Thanks.

[austriaka]

please ensure that you've removed the two Akismet files resting directly in your Addons folder when upgrading. They are replaced by the new version of Akismet Addon which comes in its own subdirectory (to go into Addons folder).
The Error Message is just a warning and should not prevent the Addons page being shown.
Add &errorsall to the URL string of your Addons page and copy ALL the notices, warnings and errors you find then

[yvette]

That did it! I had one file that was not removed. Thanks much!

[pgf]

Hallo,

I think i have the same pb than newandtrying, and i would like to know what dwilkinsjr has done in the file includes/functions.php to solve the pb ? he has hier said: "His MYSQL database was rejecting the "SHOW TABLE STATUS" command located within the includes/functions.php"

Thank you for your help, i don't know what to do :-(

Pierre

[Dkozikowski]

Open includes/functions.php and find the following code chunk:

// add new addon 2 addons table
function add_new_addons_2table($dir)
{
global $pixelpost_db_prefix;
global $pixelpost_db_pixelpost;
//start_mysql();
// Check to see if the ban table exists, if not, create it
//$query = "show tables from ".$pixelpost_db_pixelpost." like '".$pixelpost_db_prefix."addons'";
$query = "SHOW TABLES FROM `".$pixelpost_db_pixelpost."` LIKE '".$pixelpost_db_prefix."addons'";
$query = mysql_query( $query);


change $query = "SHOW TABLES FROM `".$pixelpost_db_pixelpost."` LIKE '".$pixelpost_db_prefix."addons'"; to $query = "SELECT * FROM `".$pixelpost_db_prefix."addons` LIMIT 1";

Apply the same change mentioned above to this second code chunk


// delete the row of the deleted addon
function delete_obsolute_addon($dir,$db_prefix)
{
global $pixelpost_db_prefix;
global $pixelpost_db_pixelpost;
//start_mysql();
// Check to see if the ban table exists, if not, create it
//$query = "show tables from `".$pixelpost_db_pixelpost."` like '".$pixelpost_db_prefix."addons'";
$query = "SHOW TABLES FROM `".$pixelpost_db_pixelpost."` LIKE '".$pixelpost_db_prefix."addons'";
$query = mysql_query( $query);


FYI, this code has been cleaned and reworked for the next PP release so if this helps now, you'll be all set when it comes time to upgrade.

[pgf]

change $query = "SHOW TABLES FROM `".$pixelpost_db_pixelpost."` LIKE '".$pixelpost_db_prefix."addons'"; to $query = "SELECT * FROM `".$pixelpost_db_prefix."addons` LIMIT 1";

Apply the same change mentioned above to this second code chunk
$query = "SHOW TABLES FROM `".$pixelpost_db_pixelpost."` LIKE '".$pixelpost_db_prefix."addons'";

Hallo dwilkinsjr,

I have changed the file "includes/functions.php" like above, but it's does't work = the screen ist still empty :-(

I don't see what to do !

You have done already a lot, do you think it's existe no solution ?

Pierre

[Dkozikowski]

There is always a solution. Send me a temp user/pass for your photoblog admin via private message and i'll take a closer look there. If everything is normal there than FTP access may be needed.

[krooke]

Hi there! I had to get rid of both defensio and akismet plugins or the add-ons page in the admin panel would not come up as well. I downloaded the most recent version of defensio for pixelpost from the defensio website, no luck there. I have followed your hack in the functions.php file to no avail. With Akismet the same thing appears to happen. While i don't have this problem in my "localhost" version of my site, it is occuring in my remote server, apache 2 on red hat linux with php version 5.0.2. Any ideas? Thanx!