vb.org Archive
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

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.


All times are GMT. The time now is 07:32 AM.
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

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.01244 seconds
  • Memory Usage 1,745KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete