vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Project Tools (https://vborg.vbsupport.ru/forumdisplay.php?f=266)
-   -   [PT 2.1.1] Administrative/Moderating Tools Issues (https://vborg.vbsupport.ru/showthread.php?t=244843)

KURTZ 06-18-2010 11:02 AM
[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 06-18-2010 11:06 AM
just checked the 'administrative tools' and it runs (i can open an issue) but i got this error ...


Code:
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 06-18-2010 04:38 PM
Quote:
Originally Posted by KURTZ (Post 2055371)
just checked the 'administrative tools' and it runs (i can open an issue) but i got this error ...


Code:
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 06-18-2010 07:10 PM
File ./includes/class_ptimporter.php line 518, remove the comma at the end of the line.

http://grab.by/511a

we_are_borg 06-18-2010 07:12 PM
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
Code:

pt_forwardmode = 0,
Change to
Code:

pt_forwardmode = 0
I really should learn to type faster.

KURTZ 06-19-2010 09:42 AM
just removed the coma, but the administrative tool doesn't run ...

Code:
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 06-19-2010 10:15 AM
1 Attachment(s)
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 06-19-2010 10:36 AM
Quote:
Originally Posted by we_are_borg (Post 2055775)
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 06-19-2010 11:59 AM
Quote:
Originally Posted by KURTZ (Post 2055781)
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 06-19-2010 01:18 PM
The code I provided is fully working, look correctly at commas.

KURTZ 06-19-2010 03:46 PM
Quote:
Originally Posted by PitchouneN64ngc (Post 2055837)
The code I provided is fully working, look correctly at commas.
edit: just checked, i removed a comma and added the comma @ the line 517 ... ;) this fix the administrative issue, but not the moderating tools issue ...

King Kovifor 06-19-2010 05:37 PM
What's the error with moderating tools (and how to reproduce)?

KURTZ 06-19-2010 05:41 PM
1 Attachment(s)
Quote:
Originally Posted by King Kovifor (Post 2055942)
What's the error with moderating tools (and how to reproduce)?
hi Jeremy, it's simply, every time that i try to create a new issue (thru the moderating tools) i got this message 'Invalid Action Specified' ... this happens every time ...

i fixed the administrative issue by removing and adding the comma but not the other issue ...

we_are_borg 06-19-2010 07:23 PM
When you select Create Issue from the administrative menu you can import the post as an issue without any problems you go to the page
projectpost.php?do=importthread&t=10
but when you do it trough the moderation tools you go to
inlinemod.php?threadid=10&p=
then you get the warning that says "Invalid Action Specified"

In the latests internal build i don't see the option Create Issue in the moderation tools.

King Kovifor 06-19-2010 09:16 PM
It shouldn't be in the moderation tools, as far as I am aware.

PitchouneN64ngc 06-19-2010 10:14 PM
<a href="https://vborg.vbsupport.ru/showthread.php?t=244544" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=244544</a> don't fix it? Is it the same problem?

KURTZ 06-21-2010 09:30 AM
Quote:
Originally Posted by PitchouneN64ngc (Post 2056078)
https://vborg.vbsupport.ru/showthread.php?t=244544 don't fix it? Is it the same problem?
this would be fixed in the next version correct? :p

PitchouneN64ngc 06-21-2010 11:58 AM
Indeed ;)

KURTZ 06-24-2010 09:22 AM
guys, after the fix now i got the 'create issue' option also into the 'rate this thread' (if i haven't rated previously) and 'search' tools ...

i can reproduce this issue onto another testing board ... if you need an admin account to see this issue just tell me ... ;)

PitchouneN64ngc 06-24-2010 05:27 PM
This is already fixed in 2.1.2 ;)

KURTZ 06-24-2010 06:24 PM
Quote:
Originally Posted by PitchouneN64ngc (Post 2058934)
This is already fixed in 2.1.2 ;)
OK :D


All times are GMT. The time now is 06:02 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01720 seconds
  • Memory Usage 1,768KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (21)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete