Notices

Overclockers Forums > Software > Internet, Networking, and Security
Internet, Networking, and Security Networking and Viruses/Malware trouble. Get the answers here.
Forum Jump

SQL help

Post Reply New Thread Subscribe Search this Thread
 
 
Thread Tools
Old 03-15-07, 12:53 AM Thread Starter   #1
ati
Member

 
ati's Avatar 

Join Date: Aug 2004
Location: FILIPINO DRIFTER

 
SQL help


I formatted my home server that hosts my site and now i need to reupload my sql db but when I do it it gives me this
Code:
Error

SQL query:

#
# Dumping data for table `mos_content_rating`
#
# --------------------------------------------------------
#
# Table structure for table `mos_core_acl_aro`
#
CREATE TABLE `mos_core_acl_aro` (
`aro_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`section_value` varchar( 240 ) NOT NULL default '0',
`value` varchar( 240 ) NOT NULL default '',
`order_value` int( 11 ) NOT NULL default '0',
`name` varchar( 255 ) NOT NULL default '',
`hidden` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `aro_id` ) ,
UNIQUE KEY `section_value_value_aro` ( `section_value` , `value` ) ,
UNIQUE KEY `mos_gacl_section_value_value_aro` ( `section_value` , `value` ) ,
KEY `hidden_aro` ( `hidden` ) ,
KEY `mos_gacl_hidden_aro` ( `hidden` )
) TYPE = MYISAM AUTO_INCREMENT =32;

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes
I am using a newer versino of AppServ and it has a different version of mysql so it might be that or my export of the db was wrong. Can anyone help? I have no idea what that means.

__________________
Onyx
Abit IC7
P4 3.0E @ 3.6ghz
Maxtor 300gig 16mb SATA
1gb 2x512 pc2100 @ 160mhz
nVidia 6800nu 365/777
Forton Aurora 400watt (free from stratcatprowlin:cool: )
Coolermaster Aero 7 heatsink (free from stratcatprowlin:cool: )
ati is offline   QUOTE Thanks
Old 03-15-07, 04:13 AM   #2
klingens
Member



Join Date: Apr 2002
Location: Xanadu

 
Use phpmyadmin. Don't do all at once but portion it to out to several pieces, each under 1000 bytes.
klingens is offline   QUOTE Thanks
Old 03-15-07, 06:32 AM   #3
electric sheep
Member



Join Date: Feb 2005
Location: Fairfax, VA

 
I am not familiar with AppServ, MySQL, or whatever it is you are attempting to do. But I work with SQL and can tell you what that error means.

Databases consist of tables, which consist of fields. The fields are columns of data that specify attributes for each record (row) of data. A Key is a field that is required to have a value. These Keys are used to uniquely identify each row of data. Non-Key fields can contain a value or be blank.

This message is stating that the value for one of the Key fields for a particular row of data is too long. I suspect that the newer version you are importing to has undergone database structure revisions and the max length for one of the Key fields has been reduced.

This message does not specify which field caused the error. But the message you posted lists a few Key fields. That # 1071 might indicate the row of data that caused the error; or it could represent one of many other things depending on how the program was designed. If you can find the row of data that is greater than 1000 bytes and correct it, then you should be able to restart that portion of the upgrade.
electric sheep is offline   QUOTE Thanks
Old 03-15-07, 05:24 PM Thread Starter   #4
ati
Member

 
ati's Avatar 

Join Date: Aug 2004
Location: FILIPINO DRIFTER

 
Quote:
Originally Posted by klingens
Use phpmyadmin. Don't do all at once but portion it to out to several pieces, each under 1000 bytes.

I am uploading it through phpmyadmin. How would I separate it into different pieces?

__________________
Onyx
Abit IC7
P4 3.0E @ 3.6ghz
Maxtor 300gig 16mb SATA
1gb 2x512 pc2100 @ 160mhz
nVidia 6800nu 365/777
Forton Aurora 400watt (free from stratcatprowlin:cool: )
Coolermaster Aero 7 heatsink (free from stratcatprowlin:cool: )
ati is offline   QUOTE Thanks
Old 04-02-07, 12:21 AM Thread Starter   #5
ati
Member

 
ati's Avatar 

Join Date: Aug 2004
Location: FILIPINO DRIFTER

 
Anyone?

__________________
Onyx
Abit IC7
P4 3.0E @ 3.6ghz
Maxtor 300gig 16mb SATA
1gb 2x512 pc2100 @ 160mhz
nVidia 6800nu 365/777
Forton Aurora 400watt (free from stratcatprowlin:cool: )
Coolermaster Aero 7 heatsink (free from stratcatprowlin:cool: )
ati is offline   QUOTE Thanks

Post Reply New Thread Subscribe


Overclockers Forums > Software > Internet, Networking, and Security
Internet, Networking, and Security Networking and Viruses/Malware trouble. Get the answers here.
Forum Jump

Thread Tools Search this Thread
Search this Thread:

Advanced Search


Mobile Skin
All times are GMT -5. The time now is 03:16 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
You can add these icons by updating your profile information to include your Heatware ID, Benching Profile ID or your Folding/SETI profile ID. Edit your profile!
X

Welcome to Overclockers.com

Create your username to jump into the discussion!

New members like you have made this the best community on the Internet since 1998!


(4 digit year)

Why Join Us?

  • Share experience
  • Max out your hardware
  • Best forum members anywhere
  • Customized forum experience

Already a member?