Welcome, Guest. Please login or register.

*

ShoutBox!

 

Skhilled

2024-08-09, 18:19:29
Awww! Poor thing! LOL
 

Ken

2024-08-09, 09:20:52
 

Skhilled

2024-07-06, 10:33:18
 :D
 

Ken

2024-07-06, 06:40:47
Happy Saturday after the 4th of July!
 :fireworks:
 

Skhilled

2024-07-04, 20:27:02
Happy Day Off From Work!  :D
 

Ken

2024-06-25, 06:23:12
84... who knew?  laughing7
...2013 was my *magic* year
 

Skhilled

2024-06-14, 22:09:12
I hope so! LOL
 

Ken

2024-06-14, 21:41:30
My B-Day is forthcoming and maybe it will be far enough along so that I can be a regular Dancing Fool for that day!!! :banana: :2funny:
 

Ken

2024-06-14, 21:38:38
Happy Friday everyone! I'm  SOOO glad to see Friday and not just because it's the weekend, but because it marks one more day in the recovery of my foot!  laughing7

Scrubmeister

2024-04-19, 10:32:40
Good to see the site back faster than ever. :)

Recent Topics

TP Articles


Search in titles
Search in article texts

« previous next »
Pages: [1]   Go Down

Author Topic: Getting this: Error SQL query  (Read 9252 times)

0 Members and 1 Guest are viewing this topic.

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11937
  • Gender: Male
  • View Gallery
Getting this: Error SQL query
« on: February 04, 2020, 12:23:31 PM »
I'm trying to set up XAMPP/SMF/TP on my laptop and import the OFF database into the install and the error message shown below pops up.   
Do you think that the 'aeva' tables can just be dropped(deleted) and not cause any issues with the forum? It has been several years since the avera software was uninstalled, but the tables remain eventhough they are unused.
Quote
Error

SQL query:

CREATE TABLE `smf_aeva_perms` (
 `id_group` int(11) NOT NULL default 0,
 `id_profile` int(11) NOT NULL default 0,
 `permission` varchar(255) NOT NULL default '',
 PRIMARY KEY (`id_group`, `id_profile`, `permission`)
) ENGINE=MyISAM

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes
Logged
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Skhilled

  • Administrator
  • *
  • Posts: 9424
  • Gender: Male
  • All of my passwords are protected by amnesia...
  • View Gallery
    • Buildz Hosting
Re: Getting this: Error SQL query
« Reply #1 on: February 05, 2020, 08:00:35 AM »
If the mod has been uninstalled then, yes, you can remove the tables. However, if you are getting errors in the forum logs something is still trying to call it. There's possibly still some code leftover somewhere that wasn't removed.
Logged

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11937
  • Gender: Male
  • View Gallery
Re: Getting this: Error SQL query
« Reply #2 on: February 05, 2020, 08:08:51 AM »
OK, but should these calls be happening on a database upload? All that the XAMPP install contains now is a basic SMF/TP install and when you download a backup of the OFF db and try to load it into this basic XAMPP install it will not go and gives the error that is in the first post here.
Logged
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Skhilled

  • Administrator
  • *
  • Posts: 9424
  • Gender: Male
  • All of my passwords are protected by amnesia...
  • View Gallery
    • Buildz Hosting
Re: Getting this: Error SQL query
« Reply #3 on: February 05, 2020, 08:34:46 AM »
Hmmm, I see. Try deleting the avea tables and see if that helps. If not to a repair on the db in cpanel then download a new copy of the db.
Logged

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11937
  • Gender: Male
  • View Gallery
Re: Getting this: Error SQL query
« Reply #4 on: February 05, 2020, 08:58:12 AM »
OK, I'll try that... first do a backup of the current db, then dropping the avea tables and trying a copy of that db and then as you suggest, do a repair if needed.
Logged
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Skhilled

  • Administrator
  • *
  • Posts: 9424
  • Gender: Male
  • All of my passwords are protected by amnesia...
  • View Gallery
    • Buildz Hosting
Re: Getting this: Error SQL query
« Reply #5 on: February 05, 2020, 08:59:27 AM »
A repair can't hurt. ;)
Logged

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11937
  • Gender: Male
  • View Gallery
Re: Getting this: Error SQL query
« Reply #6 on: February 05, 2020, 09:12:51 AM »
Logged
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11937
  • Gender: Male
  • View Gallery
Re: Getting this: Error SQL query
« Reply #7 on: February 05, 2020, 06:05:49 PM »
Umm... now it's giving me an error for the `smf_arcade_game_info`

After downloading a backup of the db, then dropping the avea db tables, I then downloaded a copy of the db and tried to load it into XAMPP and got the error below. At least it's not showing avea any more.  laughing7
Logged
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Skhilled

  • Administrator
  • *
  • Posts: 9424
  • Gender: Male
  • All of my passwords are protected by amnesia...
  • View Gallery
    • Buildz Hosting
Re: Getting this: Error SQL query
« Reply #8 on: February 06, 2020, 09:55:14 AM »
1.  Did you do a repair?

2.  What db are you using in XAMPP? The server is using MariaDB. That may be the difference.
Logged

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11937
  • Gender: Male
  • View Gallery
Re: Getting this: Error SQL query
« Reply #9 on: February 08, 2020, 11:16:45 AM »
Quote from: Skhilled on February 06, 2020, 09:55:14 AM
1.  Did you do a repair?

2.  What db are you using in XAMPP? The server is using MariaDB. That may be the difference.

1/ ... yes
2/ ... that name is not showing up in any of the 'Format' or 'Format-specific options' that I'm seeing


It is still giving me the same error when trying to install a copy of the OFF db into XAMPP.
Logged
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Skhilled

  • Administrator
  • *
  • Posts: 9424
  • Gender: Male
  • All of my passwords are protected by amnesia...
  • View Gallery
    • Buildz Hosting
Re: Getting this: Error SQL query
« Reply #10 on: February 09, 2020, 08:54:37 AM »
The version of XAMPP will determine what version/type of db, PHP, etc, you are using. I.E.:

This or this...or a different version.
Logged

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11937
  • Gender: Male
  • View Gallery
Re: Getting this: Error SQL query
« Reply #11 on: February 09, 2020, 02:25:52 PM »
Thanks for those links.
The version that I was using was older (how did that happen?  :o) and updating to a newer version (x64-7.4.2-0-VC15) got me closer. Uploading a copy of the OFF DB to XAMPP goes through OK and then the tables show up in PHPMyAdmin, but the site is just showing the basic new SMF/TP install and not showing the OFF copy.

Gotta do more research to find out what I'm doing wrong now.
Logged
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11937
  • Gender: Male
  • View Gallery
Re: Getting this: Error SQL query
« Reply #12 on: February 09, 2020, 03:16:11 PM »
Tried running 'repair_settings.php' on the XAMPP install just in case that might help... no joy there.
Logged
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Skhilled

  • Administrator
  • *
  • Posts: 9424
  • Gender: Male
  • All of my passwords are protected by amnesia...
  • View Gallery
    • Buildz Hosting
Re: Getting this: Error SQL query
« Reply #13 on: February 10, 2020, 02:28:52 AM »
Are you installing smf using a fresh "install" copy or using an "upgrade" copy? You should be using an upgrade version of smf otherwise smf will create it's own new db.

You have to create your own new, empty db, import the OFF db to phpmyadmin then upload the upgrade smf files. Delete the "upgrade.*" files and the ".sql" files from the root folder. You'll also need to add your own two Settings.* files  Then run repair_settings.php. You should now have an exact working copy of your forum.
Logged

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11937
  • Gender: Male
  • View Gallery
Re: Getting this: Error SQL query
« Reply #14 on: February 10, 2020, 01:10:34 PM »
Quote from: Skhilled on February 10, 2020, 02:28:52 AM
Are you installing smf using a fresh "install" copy or using an "upgrade" copy? You should be using an upgrade version of smf otherwise smf will create it's own new db.

You have to create your own new, empty db, import the OFF db to phpmyadmin then upload the upgrade smf files. Delete the "upgrade.*" files and the ".sql" files from the root folder. You'll also need to add your own two Settings.* files  Then run repair_settings.php. You should now have an exact working copy of your forum.
OK, gonna give this a try.
Logged
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.
Pages: [1]   Go Up
« previous next »