vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   New Posting Features - Doublepost Prevention (https://vborg.vbsupport.ru/showthread.php?t=233234)

physiart 03-13-2010 05:55 AM

I've tried to install the update and I had the following MySQL error:
Code:

UPDATE vp_template SET
                styleid = -10
            WHERE product = 'paulm_pdp_40' AND styleid = -1;

MySQL Error  : Duplicate entry 'editor_clientscript_pdp--10-template' for key 'title'
Error Number  : 1062
Request Date  : Saturday, March 13th 2010 @ 01:48:10 AM
Error Date    : Saturday, March 13th 2010 @ 01:48:14 AM
Script        : http://www.mydomain.com/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.mydomain.com/forums/admincp/plugin.php?do=productadd
IP Address    : 123.4.567.89
Username      : webmaster
Classname    : vB_Database
MySQL Version : 5.1.30

Now, the product is not displayed in the product list at all...
Any suggestions how to recover it?

RedHacker 03-13-2010 12:15 PM

Database error in vBulletin 4.0.2:

Invalid SQL:

UPDATE vb_template SET
styleid = -10
WHERE product = 'paulm_pdp_40' AND styleid = -1;

MySQL Error : Duplicate entry 'editor_clientscript_pdp--10-template' for key 2
Error Number : 1062
Request Date : Saturday, March 13th 2010 @ 06:14:02 AM
Error Date : Saturday, March 13th 2010 @ 06:14:06 AM
Script : http://www.xxx.xxx/admincp/plugin.php?do=productimport
Referrer : http://www.xxx.xxx/admincp/plugin.php?do=productadd
IP Address : xxx.x.xxx.xxx
Username : Administrator
Classname : vB_Database
MySQL Version : 5.0.89-community

Paul M 03-13-2010 12:46 PM

Quote:

Originally Posted by physiart (Post 2002624)
I've tried to install the update and I had the following MySQL error:

Quote:

Originally Posted by RedHacker (Post 2002766)
Database error in vBulletin 4.0.2:


Please remember to read the forum announcements.

https://vborg.vbsupport.ru/announcement.php?a=47

RedHacker 03-13-2010 01:01 PM

Quote:

Originally Posted by Paul M (Post 2002786)
Please remember to read the forum announcements.

https://vborg.vbsupport.ru/announcement.php?a=47

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'xxx_xxx.template' doesn't exist

anaksimandros 03-13-2010 01:42 PM

Database error in vBulletin 4.0.2:

Invalid SQL:

UPDATE template SET
styleid = -10
WHERE product = 'paulm_pdp_40' AND styleid = -1;

MySQL Error : Duplicate entry 'editor_clientscript_pdp--10-template' for key 2
Error Number : 1062
Request Date : Saturday, March 13th 2010 @ 05:41:35 PM
Error Date : Saturday, March 13th 2010 @ 05:41:40 PM
Classname : vB_Database
MySQL Version : 5.0.85-community

Paul M 03-13-2010 02:13 PM

@anaksimandros - Read the posts above yours.



Quote:

Originally Posted by RedHacker (Post 2002791)
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'xxx_xxx.template' doesn't exist

READ the announcement.

Quote:

Please note that template is the table name and should be typed exactly as is unless you use any tablename prefix (e.g. vb3_template).

RedHacker 03-13-2010 02:33 PM

OK I put vb_template and work....

borbole 03-13-2010 02:33 PM

I think this mod should be included as a standard built in feature for vb as it is very useful.

Alien 03-13-2010 04:37 PM

This says that the mod was updated yesterday, yet still says 4.0.1? Did you update it, or did you just update something else in your original post and not the attachment?

borbole 03-13-2010 06:10 PM

Quote:

Originally Posted by Alien (Post 2002911)
This says that the mod was updated yesterday, yet still says 4.0.1? Did you update it, or did you just update something else in your original post and not the attachment?

The mod works fine with 4.0.2 as well.


All times are GMT. The time now is 08:05 AM.

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.01484 seconds
  • Memory Usage 1,744KB
  • 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
  • (1)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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