Our FamilyForum

FamilyForum Documentation & Help => FamilyForum Features & Guidelines => Code & Stuff => Topic started by: Ken on February 04, 2020, 12:23:31 PM

Title: Getting this: Error SQL query
Post by: Ken 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
Title: Re: Getting this: Error SQL query
Post by: Skhilled 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.
Title: Re: Getting this: Error SQL query
Post by: Ken 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.
Title: Re: Getting this: Error SQL query
Post by: Skhilled 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.
Title: Re: Getting this: Error SQL query
Post by: Ken 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.
Title: Re: Getting this: Error SQL query
Post by: Skhilled on February 05, 2020, 08:59:27 AM: A repair can't hurt. ;)
Title: Re: Getting this: Error SQL query
Post by: Ken on February 05, 2020, 09:12:51 AM: Quote from: Skhilled on February 05, 2020, 08:59:27 AM
A repair can't hurt. ;)

OK laughing7
Title: Re: Getting this: Error SQL query
Post by: Ken 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
Title: Re: Getting this: Error SQL query
Post by: 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.
Title: Re: Getting this: Error SQL query
Post by: Ken 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.
(https://tinypix.top/images/2020/02/08/BBOjp.md.png) (https://tinypix.top/i/BBOjp)
Title: Re: Getting this: Error SQL query
Post by: Skhilled 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 (https://www.apachefriends.org/blog/new_xampp_20151019.html) or this (https://www.apachefriends.org/blog/new_xampp_20200205.html)...or a different version.
Title: Re: Getting this: Error SQL query
Post by: Ken 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.
Title: Re: Getting this: Error SQL query
Post by: Ken 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.
Title: Re: Getting this: Error SQL query
Post by: 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.
Title: Re: Getting this: Error SQL query
Post by: Ken 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.