Notifications
Clear all

Installation table prefix doesn't keep

3 Posts
1 Users
0 Reactions
1,727 Views
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
Topic starter
 

I just tested the install last night on a new archive. I'm confirming that the prefix on the tables (except settings) isn't keeping in the installation.

The tables are created in the database without the prefix, but the prefix is supplied, so the script looks for tables with the prefix to use. Since they don't exist, you have problems.

Editing your settings row to delete the prefix fixes it.

Same bug as this Installation help request: https://efiction.org/forums/index.php?topic=5266.0

It's the download from June 8th though, so if it was fixed afterwards and I didn't know, then never mind. πŸ™‚


Whoever said nothing is impossible never tried slamming a revolving door.

url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word

 
Posted : 07/07/2007 3:52 pm
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
Topic starter
 

Just to let you know, I'm going to try and reinstall efiction to test this bug sometime tomorrow probably, and test the rest of my open bug reports too. I would have done it sooner but I've been having computer and health problems. πŸ™


Whoever said nothing is impossible never tried slamming a revolving door.

url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word

 
Posted : 15/10/2007 1:03 am
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
Topic starter
 

It looks like it's still a problem. I tried to install a new archive on the same database.

http://.../install/install.php?step=3&install=automatic

A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfiction_authorfields` ( `field_id` int(11) NOT NULL AUTO_INCREMENT, `field_type` tinyint(4) NOT NULL default '0', `field_name` varchar(30) NOT NULL default ' ', `field_title` varchar(255) NOT NULL default ' ', `field_options` text, `field_code_in` text, `field_code_out` text, `field_on` tinyint(1) NOT NULL default '0', PRIMARY KEY (`field_id`) ) TYPE=MyISAM;
Error: (1050) Table 'fanfiction_authorfields' already exists

If I go into phpMyAdmin and edit the settings table to write in a prefix, it's able to continue and create the tables.

I'll try again when I'm not so tired to make sure that I did add a prefix in the config page when I started.


Whoever said nothing is impossible never tried slamming a revolving door.

url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word

 
Posted : 17/10/2007 2:47 am
Share: