Our FamilyForum
FamilyForum Documentation & Help => FamilyForum Features & Guidelines => Code & Stuff => Topic started 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.
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
-
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.
-
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.
-
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.
-
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.
-
A repair can't hurt. ;)
-
A repair can't hurt. ;)
OK laughing7
-
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
-
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. 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)
-
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.
-
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.
-
Tried running 'repair_settings.php' on the XAMPP install just in case that might help... no joy there.
-
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.
-
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.