vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   [APM] Advanced Product Management 2.0.4 (https://vborg.vbsupport.ru/showthread.php?t=95741)

CMX_CMGSCCC 10-03-2005 02:26 PM

I get this error when I goto Advanced Edit on a plugin.

Code:

Database error in vBulletin 3.5.0:

Invalid SQL:

                        SELECT setting.*, settinggroup.grouptitle
                        FROM forums_settinggroup AS settinggroup
                        LEFT JOIN forums_setting AS setting USING(grouptitle)
                        WHERE settinggroup.displayorder <> 0
                        WHERE settinggroup.product = 'active_link_security'
                        OR setting.product = 'active_link_security'
                        ORDER BY settinggroup.displayorder, setting.displayorder;

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 'WHERE settinggroup.product = 'active_link_security'
                        OR setti

Looks like "WHERE" is in there twice thats causing the problem.

-CMX

csidlernet 10-05-2005 02:44 AM

/installs

Kurisu 10-06-2005 08:52 PM

And I get this error when trying to import the product:

Code:

Invalid SQL:

                INSERT INTO forum_product
                        (productid, title, description, version, active, apm_releasedate, apm_author, apm_relatedurl, apm_extrainfo, apm_extraedit)
                VALUES
                        ('adv_product_management',
                        'Advanced Product Management',
                        'A powerful tool to manage product. All (codes/plugins/templates/phrases/settings) in one!',
                        '2.0',
                        1,
                        '1128232800',
                        'HacNho',
                        'https://vborg.vbsupport.ru/showthread.php?t=95741',
                        'Install\r\n\r\n- Upload files in UPLOAD folder to your server\r\n- Import XML Product (using vBulletin\'s standard Product Import tool)',
                        ''
                        );


mtha 10-06-2005 09:03 PM

Quote:

Originally Posted by Kurisu
And I get this error when trying to import the product:

Code:

Invalid SQL:

                INSERT INTO forum_product
                        (productid, title, description, version, active, apm_releasedate, apm_author, apm_relatedurl, apm_extrainfo, apm_extraedit)
                VALUES
                        ('adv_product_management',
                        'Advanced Product Management',
                        'A powerful tool to manage product. All (codes/plugins/templates/phrases/settings) in one!',
                        '2.0',
                        1,
                        '1128232800',
                        'HacNho',
                        'https://vborg.vbsupport.ru/showthread.php?t=95741',
                        'Install\r\n\r\n- Upload files in UPLOAD folder to your server\r\n- Import XML Product (using vBulletin\'s standard Product Import tool)',
                        ''
                        );


please read the install instruction:


INSTALL:

1. Upload all files in UPLOAD folder to your server
2. Import XML product product-adv_product_management.xml using vBulletin standard product import tool.
3. Refresh menu panel to display Advanced Product Management link in Plugin System section

{optional} - Re-import product-adv_product_management.xml using APM import product tool, with Allow Overwrite = Yes
This step is inserting more information into the product.
* CAUTION: DONOT use APM to import product-adv_product_management.xml BEFORE step 2.

mtha 10-06-2005 09:09 PM

Quote:

Originally Posted by CMX_CMGSCCC
I get this error when I goto Advanced Edit on a plugin.

Code:

Database error in vBulletin 3.5.0:

Invalid SQL:
                        WHERE settinggroup.displayorder <> 0
                        WHERE settinggroup.product = 'active_link_security'

Looks like "WHERE" is in there twice thats causing the problem.

-CMX

You can just delete line # 2698:

" . iif($vbulletin->debug, '', 'WHERE settinggroup.displayorder <> 0') . "

I will update in the file. Thanks :)

Omranic 10-20-2005 12:32 PM

I'm lovin' it!
Very Very Good Work
It Must Be Merged to vBulletin Default Features
Thanks alot for your work

Valter 10-20-2005 07:38 PM

Nice work. Thanks.

Installed.

Omranic 11-04-2005 09:12 AM

after upgrading to 3.5.1 & trying to uminstall a product I got the following Error ::

Fatal error: Call to undefined function: fetchtableinfo() in /hsphere/local/home/phpkd/phpkd.com/vb/admincp/apm_product.php on line 1117

this error repeated to any product uninstallation & the product doesn't uninstalled

mtha 11-05-2005 05:53 PM

Quote:

Originally Posted by SolidSnake@GTI
after upgrading to 3.5.1 & trying to uminstall a product I got the following Error ::


Fatal error: Call to undefined function: fetchtableinfo() in /hsphere/local/home/phpkd/phpkd.com/vb/admincp/apm_product.php on line 1117


this error repeated to any product uninstallation & the product doesn't uninstalled

There was few changes in function names for vB 3.5.1.

Version 2.0.3 is released to fix the problem

Please upload the new files.
(reimport XML product is recommended for hack version update)

akanevsky 11-05-2005 07:01 PM

Wow... This needs be HOTM, matey. Keep up the good work ;)
Nice coding style, too. I'll definitely install later.


All times are GMT. The time now is 09:29 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.01041 seconds
  • Memory Usage 1,749KB
  • 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
  • (4)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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