https://www.icyphoenix.com/viewtopic.php?f=26&t=3126
-----------------------------------
570thusaag
Sat 17 Nov, 2007 08:06

FAP SUPPORT - FAP Install, SQL Errors
-----------------------------------
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)
## [albumimg]Picture ID[/albumimg]
## [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!


-----------------------------------
Artie
Fri 23 Nov, 2007 18:44

Re: FAP Install, SQL Errors
-----------------------------------
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 ?

[quote user="570thusaag" post="21506"]<<<
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  [/quote]


