1 Topic by axa (edited by axa 2007-08-12 12:04)

  • axa
  • Member
  • Offline
  • From: Charlotte, NC
  • Registered: 2007-02-18
  • Posts: 63

Topic: Unable to Fetch Subscription info.

On replying to an existing post, debug mode reveals the following"-

File: /home/virtual/site133/fst/var/www/html/lmforum/post.php
Line: 218

PunBB reported: Unable to fetch subscription info

Database reported: Table 'melenie_lm.bans' doesn't exist (Errno: 1146)

I did have to do a re-import of my dbase the other day, after installing a mod that had a few things wrong with it. It appears the restore did not go too well.
Point me in the right direction ?

Edit - ok, so I restored the backup again with phpmyadmin, and got this message, pointing to the fact that it cannot import the ban table - do I manually insert it ? I would have tried this already, but the values required are confusing sad

Error

SQL query:

CREATE TABLE `bans` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`username` varchar( 200 ) default NULL ,
`ip` varchar( 255 ) default NULL ,
`email` varchar( 50 ) default NULL ,
`message` varchar( 255 ) default NULL ,
`expire` int( 10 ) unsigned default NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM AUTO_INCREMENT =10 DEFAULT CHARSET = latin1--
-- Table data for bans
--
INSERT INTO bans
VALUES (
'1', 'cecilianewman', '', 'cecilianewman@adsense4u.org', 'Fuck off and spam elsewhere', ''
);

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO bans VALUES ('1', 'cecilianewman', '', 'cecilianewman@adsense4u.org'' at line 12

Further, looking at the .sql file in notepad, it looks identical to past backups.

--
-- Table structure for bans
--

DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(200) default NULL,
  `ip` varchar(255) default NULL,
  `email` varchar(50) default NULL,
  `message` varchar(255) default NULL,
  `expire` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1

--
-- Table data for bans
--

INSERT INTO bans VALUES ('1', 'cecilianewman', '', 'cecilianewman@adsense4u.org', 'Fuck off and spam elsewhere', '');
INSERT INTO bans VALUES ('2', 'BerbasOnlien', '', '*@uganska.net', 'Fuck you spammer', '');
INSERT INTO bans VALUES ('3', 'Sakoviopka', '', 'zkpsyzssypks@itua.info', '', '');
INSERT INTO bans VALUES ('4', '', '', '*@itua.info', '', '');
INSERT INTO bans VALUES ('5', 'TurningOntoTamarron', '71.75.243.219', 'rapingkeither@gmail.com', 'Go post on myspace, unfunny gimmick', '');
INSERT INTO bans VALUES ('6', 'DrivinDelberry', '67.159.44.138', 'byefather@gmail.com', '', '');
INSERT INTO bans VALUES ('7', 'CruisinCastlebay', '', 'torturetheartist@gmail.com', '', '');
INSERT INTO bans VALUES ('8', 'DrivinDelberry', '67.159.44.138', 'byefather@gmail.com', '', '');
INSERT INTO bans VALUES ('9', 'CruisinCastlebay', '68.222.188.228', 'torturetheartist@gmail.com', '', '');

Landen Meadows Residents Forum - http://www.landenmeadows.net

axa's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Unable to Fetch Subscription info.

I think you need a ; at the end of the create table statement

3 Reply by axa (edited by axa 2007-08-12 12:19)

  • axa
  • Member
  • Offline
  • From: Charlotte, NC
  • Registered: 2007-02-18
  • Posts: 63

Re: Unable to Fetch Subscription info.

Thanks - that did enable to "bans" table to the imported and created. However, as that was fixed, the next item on the .sql file errored out, until a ; was added at the end of the create table statement, and so on.
Is it possible during backup that all of the ";" were dropped ?

Of course now the next itme to show an error on import is "categories" - as follows :-

File: /home/virtual/site133/fst/var/www/html/lmforum/forums.php
Line: 42

PunBB reported: Unable to fetch category/forum list

Database reported: Table 'melenie_lm.categories' doesn't exist (Errno: 1146)

Do I now run down the entire .sql file, inserting a ";" after each of the create table statements ?

Landen Meadows Residents Forum - http://www.landenmeadows.net

axa's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Unable to Fetch Subscription info.

Exactly. Add ;s after every create table statement

5 Reply by axa

  • axa
  • Member
  • Offline
  • From: Charlotte, NC
  • Registered: 2007-02-18
  • Posts: 63

Re: Unable to Fetch Subscription info.

Thanks - that seemed to do the trick, with one last error, which seems benign.

Error

SQL query:

INSERT INTO search_words
VALUES (
'8568', 'expos?s');

MySQL said: Documentation
#1062 - Duplicate entry 'expos' for key 1

I am sure this is not life-threatening, since it involves the search index, I rebuilt the index in the Administration module, and guess this should not negatively impact the performance of the forum.

Landen Meadows Residents Forum - http://www.landenmeadows.net

axa's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Unable to Fetch Subscription info.

Yup. If you rebuilt the search index, no issue smile

7 Reply by axa

  • axa
  • Member
  • Offline
  • From: Charlotte, NC
  • Registered: 2007-02-18
  • Posts: 63

Re: Unable to Fetch Subscription info.

Off to mods now - this seems to have affected the display of news topics on the front page by my punportal installation.....

Landen Meadows Residents Forum - http://www.landenmeadows.net

axa's Website