Database error

[Bionic Rooster]

Trying to install 3.0 on RC3 and getting this database error
Too many keys specified; max 64 keys allowed
File: /home/internt0/public_html/sasr/sasrforum/Packages/temp/galleryinstall2.0.x.php
Line: 921

Any help appreciated

[SMFHacks]

Ok we need to get a list of indexes on that table.
In phpMyAdmin window for your forum's database enter

Code: [Select]

SHOW INDEX FROM  smf_gallery_pic
Then post back the results of that query here.

[Bionic Rooster]

Code: [Select]

Table  Non_unique  Key_name  Seq_in_index  Column_name  Collation  Cardinality  Sub_part  Packed  Null  Index_type  Comment 
internt0_sasrforum_gallery_pic 0 PRIMARY 1 id_picture A 406 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 rating 1 rating A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 views 1 views A 25 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 commenttotal 1 commenttotal A 2 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_2 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_2 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_2 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_3 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_3 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_3 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_4 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_4 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_4 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_5 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_5 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_5 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_6 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_6 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_6 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_7 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_7 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_7 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_8 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_8 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_8 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_9 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_9 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_9 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_10 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_10 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_10 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_11 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_11 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_11 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_12 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_12 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_12 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_13 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_13 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_13 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_14 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_14 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_14 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_15 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_15 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_15 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_16 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_16 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_16 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_17 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_17 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_17 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_18 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_18 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_18 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_19 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_19 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_19 1 id_member A 3 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_cat_20 1 id_cat A 17 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 user_id_cat_20 1 user_id_cat A 13 NULL NULL   BTREE   
internt0_sasrforum_gallery_pic 1 id_member_20 1 id_member A 3 NULL NULL   BTREE   


[SMFHacks]

Run the following in phpmyadmin then install the gallery again

Code: [Select]

Drop INDEX id_cat_10 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_11 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_12 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_13 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_14 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_15 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_16 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_17 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_18 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_19 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_2 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_20 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_3 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_4 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_5 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_6 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_7 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_8 on internt0_sasrforum_gallery_pic;
Drop INDEX id_cat_9 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_10 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_11 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_12 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_13 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_14 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_15 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_16 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_17 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_18 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_19 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_2 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_20 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_3 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_4 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_5 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_6 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_7 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_8 on internt0_sasrforum_gallery_pic;
Drop INDEX id_member_9 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_10 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_11 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_12 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_13 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_14 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_15 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_16 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_17 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_18 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_19 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_2 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_20 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_3 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_4 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_5 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_6 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_7 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_8 on internt0_sasrforum_gallery_pic;
Drop INDEX user_id_cat_9 on internt0_sasrforum_gallery_pic;


[Bionic Rooster]

Sorry newbee here, where do I place this to run it? I've not done this before

Edit : Ok I figured where it goes and it installed fine. Thank you very much for the help