* warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sensex/domains/mysensex.com/public_html/test/sites/all/modules/drigg/drigg_pligg_import/drigg_pligg_import.module on line 289.
* warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sensex/domains/mysensex.com/public_html/test/sites/all/modules/drigg/drigg_pligg_import/drigg_pligg_import.module on line 333.
* warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sensex/domains/mysensex.com/public_html/test/sites/all/modules/drigg/drigg_pligg_import/drigg_pligg_import.module on line 360.
* warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sensex/domains/mysensex.com/public_html/test/sites/all/modules/drigg/drigg_pligg_import/drigg_pligg_import.module on line 429.
* warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sensex/domains/mysensex.com/public_html/test/sites/all/modules/drigg/drigg_pligg_import/drigg_pligg_import.module on line 458.
* warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sensex/domains/mysensex.com/public_html/test/sites/all/modules/drigg/drigg_pligg_import/drigg_pligg_import.module on line 513.
* warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sensex/domains/mysensex.com/public_html/test/sites/all/modules/drigg/drigg_pligg_import/drigg_pligg_import.module on line 529.

I am trying to import from my old pligg site to move on drigg.
every time i am trying it its throwing the above error

I am following all the steps properly

please check it to the problem

Comments

mercmobily’s picture

mercmobily commented

Hi,

Did you have a prefix in your Pligg table?
If so, the importer won't work.

Please let me know,

Merc.

iahead’s picture

iahead commented

yeah

dB name is like "pligg_talk"

and tables are in the convention of pligg_categories etc...

is that the problem ..

mercmobily’s picture

mercmobily commented

Hi,

Hummm no, that should work.
It looks like you're maybe picking the wrong DB then?
Basically, every single query to Pligg is failing on your side. Are you specifying the right DB? With the right password?

Merc.

mercmobily’s picture

mercmobily commented
Status: Active » Fixed

Poster disappeared.
Meh.

Merc.

iahead’s picture

iahead commented

i am around,,The thing is i dropped my plan on importing ;)

But still will test it again and let you know

thanks

mercmobily’s picture

mercmobily commented

Hi,

Please make sure you select the right DB _and_ that you stick around for follow up if you report again.

Thanks,

Merc.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

iahead’s picture

iahead commented
Version: 5.x-1.9 » 6.x-1.x-dev
Status: Closed (fixed) » Active

Warning: Got a packet bigger than 'max_allowed_packet' bytes query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:30680145:\"Got a packet bigger than 'max_allowed_packet' bytes\nquery: UPDATE sessions SET uid = 1, cache = 0, hostname = '59.92.193.0', session = 'messages|a:2:{s:5:\\"error\\";a:75425:{i:0;s:328:\\"user warning: Column count doesn't match value count at row 1\\nquery: INSERT INTO node VALUES (1, 2, 'drigg', 'Thinkpad T61 Review', 241, 1, 1189171642, 1212445636, 2, 1, 0, 0) in /home/pligg/domains/zixed.com/public_html/sites/all/modules/drigg/drigg_pligg_import/drigg_pligg_import.module on line 388.\\";i:1 in /home/pligg/domains/zixed.com/public_html/includes/database.mysqli.inc on line 128

I am getting this error after about 50-6% import process is over

typehost’s picture

typehost commented

I am receiving a column count mismatch error on every entry during the pligg import

user warning: Column count doesn't match value count at row 1 query: INSERT INTO tbl_users VALUES

user warning: Column count doesn't match value count at row 1 query: INSERT INTO tbl_term_data VALUES

user warning: Column count doesn't match value count at row 1 query: INSERT INTO tbl_node VALUES

user warning: Column count doesn't match value count at row 1 query: INSERT INTO tbl_term_data VALUES

(edited) --> the reference in each case is database.mysql.inc on line 174.

mercmobily’s picture

mercmobily commented
Status: Active » Closed (won't fix)

Hi,

Please do NOT reopen this bug.
It's become so messy, I can't even follow it anymore.

Please open a neww bug with _your_ error messages in the description of the bug.

Keep in mind that the importer does NOT deal with prefixed tables names in pligg.

Bye,

Merc.