UtopiaSoftware Forums

Full Version: Problem upgrading
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello
I am trying to upgrade to the newest version of NewsPro.

When I run update9.php I get the following error

Code:
Database error in Utopia News Pro:

Invalid SQL Query: CREATE TABLE `unp_bannedip` (
    `id` smallint(5) unsigned NOT NULL auto_increment,
    `ip` varchar(15) NOT NULL default '',
    `reason` varchar(100) NOT NULL default '',
    PRIMARY KEY  (`id`)
    ) TYPE=MyISAM
    
MySQL Error: Table 'unp_bannedip' already exists

MySQL Error Number: 1050

Date: February 19, 2007 07:03 AM
Script: /newspro/upgrade9.php


What am I doing wrong? and how do I fix it?


EDIT: Strangely, when I go into newspro now and click about, it says I have the most upto date version.

Have you already run that step of the upgrade before? Or maybe even the whole upgrade without noticing (only likely if you upgraded through multiple versions at once)?

If you haven't already configured banned IPs or categories, see if you can ensure that both the unp_bannedips and unp_category database tables are deleted in phpMyAdmin. Also ensure that on the Main Settings page there aren't settings called "Newsletter Emails List" and "Standard Users Sending Newsletters". If those settings DO exist, you may have already run this upgrade. If they don't, then delete the aforementioned database tables, and try to rerun upgrade9.php.
Reference URL's