Import fails - Database error 1146

Once you've installed phpList Version 2... ask questions here!
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation. This is for Version 2 of phpList (the orange one).

Problem importing mass email addresses

Postby ayakata » 12:40am, Mon 12 Feb, 2007

Hello there
I am sorry if my questions sound stupid to some experts on this forum however I am new to the phplist forum and I have some what I consider major problem questions that other might consider minors. I have read read several posts on the issues of importing and still cannot get through. I have some mass email addresses on world documents separated by commas, some are in colums while others are in rows. I have tried to import them several times using either format separately with no luck. I tried all the four given options under import but I get these messages over and over :
Database error 1146 while doing query Table 'fiezta_mentor.phplist_listattr_usastates' doesn't exist
Database error 1146 while doing query Table 'fiezta_mentor.phplist_listattr_usastates' doesn't exist
Database error 1146 while doing query Table 'fiezta_mentor.phplist_listattr_usastates' doesn't exist
Database error 1146 while doing query Table 'fiezta_mentor.phplist_listattr_usastates' doesn't exist

I only have bounch of emails, separated by commas, no first name, last name or comapny names.
Is it poosible to import these mass emails saved as world or must I change the save formats, also what must I do or steps to take to successfully import these mails.
Any help will be greatly appreciated.
Thanks again
ayakata
PL Nut
 
Posts: 18
Joined: 4:11pm, Sun 11 Feb, 2007
Location: U.S

Re: Problem importing mass email addresses

Postby H2B2 » 3:40pm, Wed 14 Feb, 2007

ayakata wrote:I get these messages over and over :
Database error 1146 while doing query Table 'fiezta_mentor.phplist_listattr_usastates' doesn't exist

It seems your are missing the above mentioned table. You could try to restore that table after first making
a full backup of your database: http://docs.phplist.com/BackupDatabase

See also: http://forums.phplist.com/viewtopic.php?p=24444

Code: Select all
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 16, 2006 at 07:50 PM
-- Server version: 3.23.58
-- PHP Version: 4.3.10
--
-- Database: `-_phplist`
--

-- --------------------------------------------------------

--
-- Table structure for table `phplist_listattr_usastates`
--

DROP TABLE IF EXISTS `phplist_listattr_usastates`;
CREATE TABLE `phplist_listattr_usastates` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `listorder` int(11) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=51 ;

--
-- Dumping data for table `phplist_listattr_usastates`
--

INSERT INTO `phplist_listattr_usastates` VALUES (1, 'Alabama', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (2, 'Alaska', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (3, 'Arizona', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (4, 'Arkansas', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (5, 'California', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (6, 'Colorado', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (7, 'Connecticut', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (8, 'Delaware', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (9, 'Florida', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (10, 'Georgia', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (11, 'Hawaii', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (12, 'Idaho', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (13, 'Illinois', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (14, 'Indiana', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (15, 'Iowa', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (16, 'Kansas', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (17, 'Kentucky', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (18, 'Louisiana', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (19, 'Maine', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (20, 'Maryland', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (21, 'Massachusetts', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (22, 'Michigan', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (23, 'Minnesota', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (24, 'Mississippi', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (25, 'Missouri', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (26, 'Montana', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (27, 'Nebraska', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (28, 'Nevada', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (29, 'New Hampshire', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (30, 'New Jersey', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (31, 'New Mexico', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (32, 'New York', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (33, 'North Carolina', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (34, 'North Dakota', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (35, 'Ohio', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (36, 'Oklahoma', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (37, 'Oregon', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (38, 'Pennsylvania', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (39, 'Rhode Island', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (40, 'South Carolina', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (41, 'South Dakota', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (42, 'Tennessee', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (43, 'Texas', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (44, 'Utah', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (45, 'Vermont', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (46, '***SPAM***', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (47, 'Washington', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (48, 'West ***SPAM***', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (49, 'Wisconsin', 0);
INSERT INTO `phplist_listattr_usastates` VALUES (50, 'Wyoming', 0);
H2B2
Moderator
 
Posts: 7188
Joined: 1:51am, Wed 15 Mar, 2006


Return to Question & Problems - after installing

Who is online

Users browsing this forum: No registered users and 5 guests