Homepage:- http://grangerenchanted.com/elysium
Upgrading from 2.0 to 3.2.1
Php:-4.4.4
MySQL:-4.1
Operating system:- Linux
Decided to upgrade on my small site before trying it on the large one and get this error when I try...restored the database but still receive this error message. Anyone help? 😀
Warning: Invalid argument supplied for foreach() in /home/grangere/public_html/elysium/header.php on line 78
A fatal MySQL error was encountered.
Query: UPDATE fanfiction_stats SET members = 28, newestmember = '29' WHERE sitekey = 'ngZXB49wHb' LIMIT 1
Error: (1146) Table 'grangere_elysium.fanfiction_stats' doesn't exist
Error: (1146) Table 'grangere_elysium.fanfiction_stats' doesn't exist
Check your database and see if the table grangere_elysium.fanfiction_stats exists, and if it doesn't try creating it. There should be table information in the docs that come with the script.
Did you have any problems or errors when you updated?
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
Ok I went into http://www.grangerenchanted.com/elysium/docs/tables.sql and there isn't a fanfiction_stats in there 🙁 I'm afraid I'm at a loss and need a little help, sorry complete novice here
-- --------------------------------------------------------
--
-- Table structure for table `fanfiction_stats`
--
CREATE TABLE `fanfiction_stats` (
`sitekey` varchar(50) collate latin1_general_ci NOT NULL default '0',
`stories` int(11) NOT NULL default '0',
`chapters` int(11) NOT NULL default '0',
`series` int(11) NOT NULL default '0',
`reviews` int(11) NOT NULL default '0',
`wordcount` int(11) NOT NULL default '0',
`authors` int(11) NOT NULL default '0',
`members` int(11) NOT NULL default '0',
`reviewers` int(11) NOT NULL default '0',
`newestmember` int(11) NOT NULL default '0'
) TYPE=MyISAM;
having the blondest moment, could be because it's 2am (groans) alright so I went into MySQL and added all the above fields in a new table called 'fanfiction_stats' and I got this when trying to save it. Am I doing it wrong or is there somewhere else I'm supposed to put it?
Error
SQL query:
CREATE TABLE `fanfiction_stats ` (
`'sitekey'` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
`'stories'` INT( 11 ) NOT NULL DEFAULT '0',
`'chapters'` INT( 11 ) NOT NULL DEFAULT '0',
`'series'` INT( 11 ) NOT NULL DEFAULT '0',
`'reviews'` INT( 11 ) NOT NULL DEFAULT '0',
`'wordcount'` INT( 11 ) NOT NULL DEFAULT '0',
`'authors'` INT( 11 ) NOT NULL DEFAULT '0',
`'members'` INT( 11 ) NOT NULL DEFAULT '0',
`'reviewers'` INT( 11 ) NOT NULL DEFAULT '0',
`'newestmember'` INT( 11 ) NOT NULL DEFAULT '0'
) ENGINE = MYISAMMySQL said: Documentation
#1103 - Incorrect table name 'fanfiction_stats '
Try taking out the collate info.
alright got this again...
Error
SQL query:
CREATE TABLE `fanfiction_stats ` (
`'sitekey'` VARCHAR( 50 ) NOT NULL DEFAULT '0',
`'stories'` INT( 11 ) NOT NULL DEFAULT '0',
`'chapters'` INT( 11 ) NOT NULL DEFAULT '0',
`'series'` INT( 11 ) NOT NULL DEFAULT '0',
`'reviews'` INT( 11 ) NOT NULL DEFAULT '0',
`'wordcount'` INT( 11 ) NOT NULL DEFAULT '0',
`'authors'` INT( 11 ) NOT NULL DEFAULT '0',
`'members'` INT( 11 ) NOT NULL DEFAULT '0',
`'reviewers'` INT( 11 ) NOT NULL DEFAULT '0',
`'newestmember'` INT( 11 ) NOT NULL DEFAULT '0'
) ENGINE = MYISAMMySQL said: Documentation
#1103 - Incorrect table name 'fanfiction_stats '
When you first created the table, you created a table called fanfiction_stats, right? Well I don't think that you can create two of the same table. Drop the old one(s). And try again. 🙂
-- --------------------------------------------------------
--
-- Table structure for table `fanfiction_stats`
--
CREATE TABLE `fanfiction_stats` (
`sitekey` varchar(50) NOT NULL default '0',
`stories` int(11) NOT NULL default '0',
`chapters` int(11) NOT NULL default '0',
`series` int(11) NOT NULL default '0',
`reviews` int(11) NOT NULL default '0',
`wordcount` int(11) NOT NULL default '0',
`authors` int(11) NOT NULL default '0',
`members` int(11) NOT NULL default '0',
`reviewers` int(11) NOT NULL default '0',
`newestmember` int(11) NOT NULL default '0'
) TYPE=MyISAM;
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
