Page 1 of 1

Problem importing mass email addresses

PostPosted: 12:40am, Mon 12 Feb, 2007
by ayakata
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

Re: Problem importing mass email addresses

PostPosted: 3:40pm, Wed 14 Feb, 2007
by H2B2
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);