* user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: UPDATE acidfree_hierarchy SET parent=2147 WHERE parent=-1 AND child IN (,) in /home/content/l/a/r/larrysafir/html/includes/database.mysql.inc on line 120.
* Found 2 Acidfree root albums, new root is node 2147

if you want to see this error in action, go to www.995quepasa.com and click on the image gallery.

Help Please , I'm completely lost

CommentFileSizeAuthor
#3 acidfree_breaks.png51.51 KBMikeyGYSE

Comments

anthon1’s picture

anthon1 commented

OK, the problem is not fixed, but I had to do something, we have a high traffic site, and the error just kept getting worse everytime someone tried to look at the pictures. I commented out that part of the acidfree.module (lines 1884 - 1917)

Of course I cant add any new albums and when you upload photos no albums show up to select. But it's ok. I have faith in you guys, and I know you can give me some great support in getting this resolved.

Thanks

MikeyGYSE’s picture

MikeyGYSE commented
Title: Acidfree wont stop creating new root ablums!! Help » Acidfree Creating over 4000 root albums
Component: Miscellaneous » Code

Acidfree has been nothing but trouble so far, have used it in the past and it was fantastic however what with having to manually create it's database tables and having it run haywire and create over 4000 albums is NOT ON!

This needs to be fixed, quickly!

/* $Id: acidfree.module,v 1.62.2.58 2006/10/24 14:32:49 vhmauery Exp $ */

Drupal Version 4.7.4

Not only has it given me tons of extra work to do what with manually removing the content but my pathauto module is STILL trying to create aliases for all of these albums...

MikeyGYSE’s picture

MikeyGYSE commented
StatusFileSize
new acidfree_breaks.png51.51 KB

Attached Screenshot showing phpMyAdmin viewing 999 rows on page 5...

I've had to disable the module because it just... keeps .... going!

MikeyGYSE’s picture

MikeyGYSE commented

The final count was actually 18,642 albums,

Anyone else having the same issue, there is a simple way to remove the albums:

First: Empty the "acidfree" and "acidfree_heirarchy" tables,

Second: Establish the NID of the FIRST AcidFree album (from the "node" table.)

Then run the following:

DELETE FROM `node` WHERE `nid` > NID;

Replacing NID with the NID of the first album.

It saves you manually removing them...

vhmauery’s picture

vhmauery commented

Look MikeyGYSE, I would love to help you, but there is obviously something that you have done to botch your install. Try starting over with a *NEW* install of drupal and acidfree and see if that works for you. I don't see this problem myself or I would have fixed it.

There are thousands of other acidfree users that are very happy, so stop pointing your finger at acidfree.

anthon1’s picture

anthon1 commented

OK, here's what I've been able to work out.

Apparently if the function, "function _acidfree_fix_root" for whatever reason gets more than one item with a parent id of "-1" it will create more root nodes. I dont know all the particulars as to why and how it happened in the first place, and such, but if you want to fix it do this;

Make sure that in the table acidfree_hierarchy, there is only ONE entry with a parent value of -1. Once that is set, make sure you uncomment the "function_acidfree_fix_root" from the acidfree.module (If you had commented it in the first place, otherwise ignore this part)

Good luck to all.

Sincerely
Anthony

MikeyGYSE’s picture

MikeyGYSE commented
Status: Active » Closed (fixed)

Closed this issue, the developer who commented doesn't seem phased so I'll guess that it is a glitch in my drupal install, unlikely as that may be.