[PT 2.1.1] Administrative/Moderating Tools Issues

hi guys, i've a trouble, when i select a specific post and i wanna to make it an issue (create issue option) i got always this message 'Invalid Action Specified' ... what's wrong? i'm the superadmin ... what i need to check?

TIA

[KURTZ]

just checked the 'administrative tools' and it runs (i can open an issue) but i got this error ...

Database error in vBulletin 4.0.4:

Invalid SQL:

				UPDATE thread SET
					pt_issueid = 1
					pt_forwardmode = 0,
				WHERE threadid = 4;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pt_forwardmode = 0,
				WHERE threadid = 4' at line 3
Error Number  : 1064
Request Date  : Friday, June 18th 2010 @ 07:03:37 AM
Error Date    : Friday, June 18th 2010 @ 07:03:37 AM
Script        : http://www.xxx.it/latest/projectpost.php?do=processimportthread&t=4
Referrer      : http://www.xxx.it/latest/projectpost.php?do=importthread2&t=4
IP Address    : xxx
Username      : MR K
Classname     : vB_Database
MySQL Version : 5.0.91

i'm onto a fresh new vB install ...

[we_are_borg]

Originally Posted by KURTZ

just checked the 'administrative tools' and it runs (i can open an issue) but i got this error ...

Database error in vBulletin 4.0.4:

Invalid SQL:

				UPDATE thread SET
					pt_issueid = 1
					pt_forwardmode = 0,
				WHERE threadid = 4;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pt_forwardmode = 0,
				WHERE threadid = 4' at line 3
Error Number  : 1064
Request Date  : Friday, June 18th 2010 @ 07:03:37 AM
Error Date    : Friday, June 18th 2010 @ 07:03:37 AM
Script        : http://www.xxx.it/latest/projectpost.php?do=processimportthread&t=4
Referrer      : http://www.xxx.it/latest/projectpost.php?do=importthread2&t=4
IP Address    : xxx
Username      : MR K
Classname     : vB_Database
MySQL Version : 5.0.91

i'm onto a fresh new vB install ...

I have duplicated this on our internal PT will make a ticket and ask if some one can make a workaround because you cant use the promote to PT.

[PitchouneN64ngc]

File ./includes/class_ptimporter.php line 518, remove the comma at the end of the line.

[we_are_borg]

A developer as changed this for the next release. You can manually change a file to get it working.

In "class_ptimporter.php" in the includes directory

Line 518 find

pt_forwardmode = 0,

Change to

pt_forwardmode = 0

I really should learn to type faster.

[KURTZ]

just removed the coma, but the administrative tool doesn't run ...

Database error in vBulletin 4.0.4:

Invalid SQL:

				UPDATE thread SET
					pt_issueid = 2
					pt_forwardmode = 0
				WHERE threadid = 4;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pt_forwardmode = 0
				WHERE threadid = 4' at line 3
Error Number  : 1064
Request Date  : Saturday, June 19th 2010 @ 05:39:44 AM
Error Date    : Saturday, June 19th 2010 @ 05:39:45 AM
Script        : http://www.xxx.it/latest/projectpost.php?do=processimportthread&t=4
Referrer      : http://www.xxx.it/latest/projectpost.php?do=importthread2&t=4
IP Address    : xxxx
Username      : MR K
Classname     : vB_Database
MySQL Version : 5.0.91

also i got the same error with the moderating tools (invalid action) ...

[we_are_borg]

Be sure to backup the file first

I have included the file in an attachement download the file and rename it to "class_ptimporter.php" after that upload it to ./includes/ and overwrite the file there.

I'm now using this file in my test setup and it's working as it should.

[KURTZ]

Originally Posted by we_are_borg

Be sure to backup the file first

I have included the file in an attachement download the file and rename it to "class_ptimporter.php" after that upload it to ./includes/ and overwrite the file there.

I'm now using this file in my test setup and it's working as it should.

nothing mate, it doesn't run ... if you need i can send you an admin account onto my testing board so you can check yourself ... :S

[we_are_borg]

Originally Posted by KURTZ

nothing mate, it doesn't run ... if you need i can send you an admin account onto my testing board so you can check yourself ... :S

If you can do that it would be great, also ftp account should come handy.

[PitchouneN64ngc]

The code I provided is fully working, look correctly at commas.