vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Private Messages Enhancements - Private Message Attachments (https://vborg.vbsupport.ru/showthread.php?t=284138)

Taurus1 06-10-2012 01:44 PM

I ran it on my test site first. No problems. How was I to know that following his instructions on uninstalling would cause this?

Andreas 06-10-2012 03:11 PM

Quote:

I ran it on my test site first. No problems.
Did you test that uninstalling Beta 1 (and afterwards installing Beta 2) on a test installation works without problems?

Anyway, manually fixing the DB is quite a bit complicated - you can look at the installation/uninstallation code (which has been updated to fix the bugs you came across) to get an idea what needs to be done.

kevius 06-12-2012 07:50 AM

Any idear about the final version date ?

Altari 06-12-2012 09:45 AM

Not working for me, errors during the installation :
Database error in vBulletin 4.2.0:

Code:

Invalid SQL:

      UPDATE vb_pm AS pm
      SET attach = (SELECT COUNT(*) FROM vb_attachment WHERE contentid = pm.pmid AND attachment.contenttypeid = );

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 ')' at line 2
Error Number  : 1064

Moroever, after a lot of try, i can see
Code:

[Tue Jun 12 12:29:32 2012] [warn] [client XXX] mod_fcgid: stderr: PHP Warning:  Invalid argument supplied for foreach() in /var/www/packages/navmanenhancements/admin.php on line 43, referer: http://website/admincp/plugin.php?do=productadd
in my apache error log. Don't know what your other addon is doing here...


Thank you Andreas for this mod, would be great.

Andreas 06-14-2012 04:34 AM

Quote:

Originally Posted by kevius (Post 2338904)
Any idear about the final version date ?

It's ready when it's ready, eg. when there are no more bugs being reported.

@Altari
Thanks for this bug report, it will be fixed in Beta 3.

betterthanyours 06-16-2012 02:11 PM

Another one

Code:

Database error in vBulletin 4.1.12:

Invalid SQL:

        INSERT INTO package
        (productid, class)
        VALUES
        ('pmattachments', 'PMAttachments');

MySQL Error  : Duplicate entry 'PMAttachments' for key 'class'
Error Number  : 1062
Request Date  : Saturday, June 16th 2012 @ 11:10:43 AM
Error Date    : Saturday, June 16th 2012 @ 11:10:43 AM
Script        : http://www.unrealkillers.com/admincp/plugin.php?do=productimport
Referrer      : http://www.unrealkillers.com/admincp/plugin.php?do=productadd
IP Address    : 86.19.247.18
Username      : $carface
Classname    : vB_Database
MySQL Version : 5.5.24-cll


Syxguns 06-25-2012 06:18 AM

I am awaiting this mod! I've got it tagged. Thanks for this Andreas :D

qpurser 06-25-2012 10:50 AM

Andreas,
just wanted to give you some feedback regarding your once again excellent mod.

Running vb 4.2.0 on a test server
Upgraded from your Beta1 to Beta2. (for those reading this I did NOT uninstall Beta1 and then installed Beta2 but did a regular update)

I didn't get any error messages at all
Sending and receiving the attachments worked just fine

On a side note I am using also DBTech "vb optimize" which moves the attachments from the database to a folder as files.
Your plugin works fine with or without this add-on.

horusbird 06-30-2012 06:19 PM

error in installation:

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

        INSERT INTO package
        (productid, class)
        VALUES
        ('pmattachments', 'PMAttachments');

MySQL Error  : Duplicate entry 'PMAttachments' for key 'class'
Error Number  : 1062
Request Date  : Saturday, June 30th 2012 @ 09:18:19 PM
Error Date    : Saturday, June 30th 2012 @ 09:18:19 PM
Script        : http://www.vesparesources.com/adminc...=productimport
Referrer      : http://www.vesparesources.com/adminc...?do=productadd
IP Address    : 79.13.184.169
Username      : horusbird
Classname    : vB_Database
MySQL Version : 5.1.33-community


betterthanyours 07-03-2012 07:07 PM

Quote:

Originally Posted by betterthanyours (Post 2340063)
Another one

Code:

Database error in vBulletin 4.1.12:

Invalid SQL:

        INSERT INTO package
        (productid, class)
        VALUES
        ('pmattachments', 'PMAttachments');

MySQL Error  : Duplicate entry 'PMAttachments' for key 'class'
Error Number  : 1062
Request Date  : Saturday, June 16th 2012 @ 11:10:43 AM
Error Date    : Saturday, June 16th 2012 @ 11:10:43 AM
Script        : http://www.unrealkillers.com/admincp/plugin.php?do=productimport
Referrer      : http://www.unrealkillers.com/admincp/plugin.php?do=productadd
IP Address    : 86.19.247.18
Username      : $carface
Classname    : vB_Database
MySQL Version : 5.5.24-cll


Quote:

Originally Posted by horusbird (Post 2344109)
error in installation:

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:

        INSERT INTO package
        (productid, class)
        VALUES
        ('pmattachments', 'PMAttachments');

MySQL Error  : Duplicate entry 'PMAttachments' for key 'class'
Error Number  : 1062
Request Date  : Saturday, June 30th 2012 @ 09:18:19 PM
Error Date    : Saturday, June 30th 2012 @ 09:18:19 PM
Script        : http://www.vesparesources.com/adminc...=productimport
Referrer      : http://www.vesparesources.com/adminc...?do=productadd
IP Address    : 79.13.184.169
Username      : horusbird
Classname    : vB_Database
MySQL Version : 5.1.33-community


Any news on this error?


All times are GMT. The time now is 10:21 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.01247 seconds
  • Memory Usage 1,751KB
  • 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
  • (6)bbcode_code_printable
  • (4)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