Our FamilyForum

*

ShoutBox!

 

Ken

2025-02-03, 07:21:34
Wow! That is crazy!      
laughing7
 

Skhilled

2025-02-02, 20:21:47
It's snowing like crazy outside but tomorrow it's supposed to go up to the 50's! LOL
 

Ken

2025-01-25, 20:41:18
 shocked003
 

Skhilled

2025-01-25, 20:37:14
It's currently 26° which is warm as far as the rest of the week went. We were in the single digits since last weekend!
 

Ken

2025-01-25, 20:13:20

shocked003
 

Ken

2025-01-01, 13:09:08
 :fireworks3:
 

Skhilled

2024-12-31, 21:02:30
 :fireworks:
 

Skhilled

2024-12-09, 18:46:19
Thanks! And to you both as well. :)
 

Ken

2024-12-09, 17:11:29
Thanks Robert, and Merry Christmas to you and Charlie as well!  :heart:

UncleBob

2024-12-08, 19:40:05
Wishing everyone a great Christmas. From Lee (Robert) and Charlie (Pricilla). Have a good '25, too.

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 11376 times)

0 Members and 1 Guest are viewing this topic.

Offline Ken (OP)

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 12037
  • 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: 9540
  • 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: 12037
  • 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: 9540
  • 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: 12037
  • 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: 9540
  • 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: 12037
  • 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: 12037
  • 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: 9540
  • 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: 12037
  • 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: 9540
  • 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: 12037
  • 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: 12037
  • 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: 9540
  • 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: 12037
  • 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 »