Hi, I updated to PunBB 1.2.15 and now I am getting inundated by spam, previously akismet plug in kept it all out, but now akismet reports "no new spam". Is it possible that akismet plugin doesnt work with PunBB 1.2.15 ?
Cheers
chantaspell
2 2007-04-20 12:33
Re: Can't restore from backup (6 replies, posted in PunBB 1.2 troubleshooting)
That worked a treat! Thanks a million 
3 2007-04-19 14:23
Re: Can't restore from backup (6 replies, posted in PunBB 1.2 troubleshooting)
Hmmmm, so if the back up file consists of many segments like the two below, where do I add the semicolons?
--
-- Table structure for access
--
DROP TABLE IF EXISTS `access`;
CREATE TABLE `access` (
`aid` int(11) NOT NULL auto_increment,
`mask` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`status` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
--
-- Table structure for akismet
--
CREATE TABLE `akismet` (
`id` int(10) unsigned NOT NULL auto_increment,
`poster` varchar(200) NOT NULL default '',
`poster_id` int(10) unsigned NOT NULL default '1',
`poster_ip` varchar(15) default NULL,
`poster_email` varchar(50) default NULL,
`subject` varchar(255) NOT NULL default '',
`message` text NOT NULL,
`hide_smilies` tinyint(1) NOT NULL default '0',
`posted` int(10) unsigned NOT NULL default '0',
`edited` int(10) unsigned default NULL,
`edited_by` varchar(200) default NULL,
`topic_id` int(10) unsigned NOT NULL default '0',
`forum_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Many thanks again!
4 2007-04-18 21:42
Re: Can't restore from backup (6 replies, posted in PunBB 1.2 troubleshooting)
Hi
Sorry, forgot to say, i used the "backup" module ap_backup.php
Cheers
c
5 2007-04-18 17:23
Topic: Can't restore from backup (6 replies, posted in PunBB 1.2 troubleshooting)
Hi
I have a backup file but when I try to restore it i get the error message
"Error imported backup file, the database probably has not been restored"
I am using the "DB management" plugin.
When I try and upload it through phpmyadmin i get the following error:
------------------------------------------------------------------------------
SQL query:
CREATE TABLE `access` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`mask` varchar( 255 ) NOT NULL default '',
`type` varchar( 255 ) NOT NULL default '',
`status` tinyint( 4 ) NOT NULL default '0',
PRIMARY KEY ( `aid` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8--
-- Table structure for akismet
--
CREATE TABLE `akismet` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`poster` varchar( 200 ) NOT NULL default '',
`poster_id` int( 10 ) unsigned NOT NULL default '1',
`poster_ip` varchar( 15 ) default NULL ,
`poster_email` varchar( 50 ) default NULL ,
`subject` varchar( 255 ) NOT NULL default '',
`message` text NOT NULL ,
`hide_smilies` tinyint( 1 ) NOT NULL default '0',
`posted` int( 10 ) unsigned NOT NULL default '0',
`edited` int( 10 ) unsigned default NULL ,
`edited_by` varchar( 200 ) default NULL ,
`topic_id` int( 10 ) unsigned NOT NULL default '0',
`forum_id` int( 10 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1--
-- Table structure for authmap
--
DROP TABLE IF EXISTS `authmap` ;
MySQL said:
#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 'CREATE TABLE `akismet` (
`id` int(10) unsigned NOT NULL auto_i
----------------------------------------------------------
Any ideas? many thanks
Chantaspell