Icy Phoenix

Trying to install Full Album Pack-

Running the sql, I got three errors:
DROP TABLE `phpbb_album_sp_config`
+++ Error: Unknown table 'phpbb_album_sp_config'

ALTER TABLE `phpbb_album_cat` ADD `cat_parent` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_approval`
+++ Error: Duplicate column name 'cat_parent'

ALTER TABLE `phpbb_album_cat` ADD `cat_user_id` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NULL AFTER `cat_parent`
+++ Error: Duplicate column name 'cat_user_id'


Now, the drop table my intuition says don't worry about... I guess that would be a table from a previous version, or other mod that this mod would supercede. At any rate, being a novice I still sense that when it tells me it couldn't delete something that I should not worry about it.

But the other two???

How do I interperate this? What should I do? I don't want to go any further and waste time installing until I know what is going on...



(The rest was posted after adding the mod)


After installing the mod, I have now come across the following error message:


<<<
DEBUG MODE

SQL Error : 1064 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 ') AND pic_cat_id = cat_id' at line 3

SELECT COUNT(pic_id) AS count FROM phpbb_album, phpbb_album_cat WHERE cat_id IN () AND pic_cat_id = cat_id

Line : 341
File : album_allpics.php>>>

Is this error, above, related to the error message on the SQL errors I got after I ran the queries?? They sure appear to be...

How should I address this error that says that a table already exists???

Or am I misreading some of this?

I looked in my SQL database directory, and the tables exist--- but they say "unsigned" under attributes... I don't know what that means, but I mention it as only three databases in that whole database say that, and they are the databases in question here. ----cat_id, cat_parent, and cat_user_id----

Something is UP!

The mods I have installed that I suspect might have created the table/column conflict could be:
Add-On_categories_hierarchy
random_custom_logo

No idea other than that...


ADDITIONALY:
I am not seeing the bbcodes listed:
## Album Image BBCode
## =======================================
## Five BBCodes added:
## [fullalbumimg]Picture ID[/fullalbumimg] (Mid Thumb Image)
##
## [albumimgl]Picture ID[/albumimgl] (Left Alignment)
## [albumimgr]Picture ID[/albumimgr] (Right Alignment)
## [albumimgc]Picture ID[/albumimgc] (Center Alignment)

Are these supposed to be in the posting area with all of the other tags???


I know that is a lot of info and questions, but please help if you can!

Are you still having problems ?


All the errors you got from running the file fap_install.php can most likely be ignored.

The error quoted below has been mentioned before, I believe. I do not know the cause, but I believed it to be fixed already.
What are you doing that produces this error ?

570thusaag wrote: [View Post]

<<<
DEBUG MODE

SQL Error : 1064 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 ') AND pic_cat_id = cat_id' at line 3

SELECT COUNT(pic_id) AS count FROM phpbb_album, phpbb_album_cat WHERE cat_id IN () AND pic_cat_id = cat_id