Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 11839
Latest: BugginIn
New This Month: 2
New This Week: 0
New Today: 0
Stats
Total Posts: 42423
Total Topics: 7395
Most Online Today: 159
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 93
Total: 93

Author Topic: Database error  (Read 5042 times)

0 Members and 1 Guest are viewing this topic.

Offline Bionic Rooster

  • Jr. Member
  • **
  • Posts: 52
    • View Profile
Database error
« on: April 03, 2010, 09:23:38 pm »
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

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16086
    • View Profile
Re: Database error
« Reply #1 on: April 03, 2010, 09:33:15 pm »
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.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Bionic Rooster

  • Jr. Member
  • **
  • Posts: 52
    • View Profile
Re: Database error
« Reply #2 on: April 03, 2010, 10:11:08 pm »
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   

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16086
    • View Profile
Re: Database error
« Reply #3 on: April 03, 2010, 10:17:05 pm »
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;
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Bionic Rooster

  • Jr. Member
  • **
  • Posts: 52
    • View Profile
Re: Database error
« Reply #4 on: April 03, 2010, 10:34:34 pm »
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  ;D
« Last Edit: April 03, 2010, 10:42:03 pm by Bionic Rooster »

 

Related Topics

  Subject / Started by Replies Last post
10 Replies
9161 Views
Last post February 24, 2009, 08:08:08 pm
by Beltazar
Database Error

Started by pioneer « 1 2 » Support

22 Replies
11595 Views
Last post April 18, 2009, 11:58:55 am
by SMFHacks
5 Replies
5460 Views
Last post January 22, 2010, 11:26:48 am
by SMFHacks
4 Replies
4848 Views
Last post April 22, 2010, 11:12:32 am
by SMFHacks
4 Replies
4672 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks

+- Recent Topics

Custom badges by Hatshepsut
Today at 10:10:46 pm

Membergroup level by davejo
Today at 02:13:49 am

Setting a single free download. by SMFHacks
August 16, 2022, 09:50:04 am

Quick moderation checkboxes in search result? by SMFHacks
August 08, 2022, 10:37:03 am

Contact Page Mod Not Working by SMFHacks
August 05, 2022, 12:19:43 pm

Issues with new Newsletter Pro installation by SMFHacks
August 05, 2022, 07:15:18 am

SMFBlog Mod by Nicole
August 03, 2022, 09:46:22 pm

Contact Page by Nicole
August 03, 2022, 09:45:42 pm

trader + classifieds by Nicole
August 03, 2022, 05:05:17 pm

Category Permissions List by SMFHacks
July 30, 2022, 07:53:24 am

Powered by EzPortal