Database Error while importing product

[DertyLee]

Got this error while importing:

Database error in vBulletin 3.6.7:

Invalid SQL:

REPLACE INTO datastore
(title, data, unserialize)
VALUES
('pt_assignable', 'a:1:{i:1;a:3:{s:3:\"bug\";a:16584:{i:8175;s:13:\

all users

";}}}', 1);

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Date : Monday, July 16th 2007 @ 05:53:18 AM
Script : http://www.*****.**/forum/admincp/plugin.php?do=productimport
Referrer : http://www.*****.**/forum/admincp/plugin.php?do=productadd
IP Address : **.**.**.**
Username : *******
Classname : vb_database


I optimized all tables run import again and now I get this:



Database error in vBulletin 3.6.7:

Invalid SQL:

CREATE TABLE pt_issue (
issueid INT UNSIGNED AUTO_INCREMENT NOT NULL,
projectid INT UNSIGNED NOT NULL DEFAULT 0,
issuestatusid INT UNSIGNED NOT NULL DEFAULT 0,
issuetypeid VARCHAR(25) NOT NULL DEFAULT '',
title VARCHAR(250) NOT NULL DEFAULT '',
summary VARCHAR(250) NOT NULL DEFAULT '',
submituserid INT UNSIGNED NOT NULL DEFAULT 0,
submitusername VARCHAR(100) NOT NULL DEFAULT '',
submitdate INT UNSIGNED NOT NULL DEFAULT 0,
appliesversionid INT UNSIGNED NOT NULL DEFAULT 0,
isaddressed SMALLINT UNSIGNED NOT NULL DEFAULT 0,
addressedversionid INT UNSIGNED NOT NULL DEFAULT 0,
priority SMALLINT UNSIGNED NOT NULL DEFAULT 1,
visible ENUM('moderation', 'visible', 'private', 'deleted') NOT NULL DEFAULT 'visible',
lastpost INT UNSIGNED NOT NULL DEFAULT 0,
lastactivity INT UNSIGNED NOT NULL DEFAULT 0,
lastpostuserid INT UNSIGNED NOT NULL DEFAULT 0,
lastpostusername VARCHAR(100) NOT NULL DEFAULT '',
firstnoteid INT UNSIGNED NOT NULL DEFAULT 0,
lastnoteid INT UNSIGNED NOT NULL DEFAULT 0,
attachcount INT UNSIGNED NOT NULL DEFAULT 0,
pendingpetitions INT UNSIGNED NOT NULL DEFAULT 0,
replycount INT UNSIGNED NOT NULL DEFAULT 0,
votepositive INT UNSIGNED NOT NULL DEFAULT 0,
votenegative INT UNSIGNED NOT NULL DEFAULT 0,
projectcategoryid INT UNSIGNED NOT NULL DEFAULT 0,
assignedusers INT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (issueid),
KEY finder (projectid, visible, issuetypeid, lastpost),
KEY issuestatusid (issuestatusid),
FULLTEXT KEY textsearch (title, summary)
) ENGINE=MYISAM;

MySQL Error : Table 'pt_issue' already exists Error Number : 1050
Date : Monday, July 16th 2007 @ 06:08:04 AM
Script : http://www.*****.**/forum/admincp/plugin.php?do=productimport
Referrer : http://www.*****.**/forum/admincp/plugin.php?do=productadd
IP Address : **.**.**.**
Username : *******
Classname : vb_database

Any help?

[PitchouneN64ngc]

For the first error, you can have your answer here: http://www.vbulletin.com/forum/showthread.php?t=235499

For the second, this error happens when you have installed or tried to install Project Tools, tables already exists. You can delete them directly in your database (phpMyadmin or any similar system).

[DertyLee]

Thanks, issue solved.