vb.org Archive
Page 12 of 16 « First 21011 12 1314 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   PM Attachments 3.5 (https://vborg.vbsupport.ru/showthread.php?t=95477)

LincolnForums 02-01-2006 02:25 AM
couldnt get to work on my php5 and mysql5 server, could it be just an issue with that?

DruidToolz 02-06-2006 09:25 PM
I am also having a problem getting this to work.. What i am getting is this...

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE pmtext SET attach='1' WHERE pmtextid='175';

MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Monday, February 6th 2006 @ 05:18:56 PM
Script : http://**********/forum/private.php
Referrer : http://**********/forum/private.php?do=newpm&u=31
IP Address : **.***.**.**
Username : DruidToolz
Classname : vbdatabase

Could someone help me please.. Thnx in advance

Kimah72 03-09-2006 05:14 PM
Hi, I got everything changed but when I went to do the SQL Queries, I ran into
Quote:
error number: 1146
error desc: Table 'momswit_Forum.attachment' doesn't exist
also when running all of them at the same time, I get this error.

Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
ALTER TABLE attachment add itemid int not null;
ALTER TABLE
I don't know what I am missing. Could you please help? This would be a nice hack to have on my board. Thanks! :)

dsotmoon 03-10-2006 10:43 PM
is this working ok in 3.5.4 ?

DruidToolz 03-11-2006 01:32 AM
Well i have all the modifications setup up on 3.5.4 I just wish there was an easier way then editing the sql query tables.. The reason i say this is i got a failed message which i didn't want to try it again unless i either backup my database or write over it and hope it doesn't mess up.. So please can someone help me with this.. Thnx

GoodKarmaKid 03-26-2006 05:54 AM
I was cruising right through the installation with no problems right up until the sql query. I wasn't able to execute an sql query from the vb control panel? I've installed several other hacks without a problem.

Presumably has something to do with access read/write permissions for the database? Opened up the file manager from my web control panel and the folder permissions seemed to be set correctly. I opend up myphpadmin and was going to try and run the querys from the tables following the instructions but quickly got in over my head.

The easiest thing for me would probably be just to execute the query from the vb control panle.

Any help in pointing me in the right direction to execute the sql query would be appreciated.

Thanks,
Jason

https://vborg.vbsupport.ru/external/2006/03/3.jpg

Rickie3 03-26-2006 09:49 AM
Quote:
Originally Posted by GoodKarmaKid
I was cruising right through the installation with no problems right up until the sql query. I wasn't able to execute an sql query from the vb control panel? I've installed several other hacks without a problem.

Presumably has something to do with access read/write permissions for the database? Opened up the file manager from my web control panel and the folder permissions seemed to be set correctly. I opend up myphpadmin and was going to try and run the querys from the tables following the instructions but quickly got in over my head.

The easiest thing for me would probably be just to execute the query from the vb control panle.

Any help in pointing me in the right direction to execute the sql query would be appreciated.

Thanks,
Jason

https://vborg.vbsupport.ru/external/2006/03/3.jpg
you need to edit your config.php with your id to allow to run queries,go to your server where your forum is installed then find includes folder inside the includes folder you will find config.php look for this code note in my code id is set at 1,edit to your user id then save you will now be able to run queries from your admin CP hope that helps
Code:
//        ****** USERS WITH QUERY RUNNING PERMISSIONS ******
        //        The users specified here will be allowed to run queries from the control panel.
        //        See the above entries for more information on the format.
        //        Please note that the ability to run queries is quite powerful. You may wish
        //        to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '1';

gcphost 03-28-2006 07:21 AM
Hey all I am able to upload images and possibly other items but im trying to upload a tar.gz, it uploads with no problem (so it seems) but when adding to mysql its adding the content of the binary to the db causing this:

Code:
Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO vb_attachment
        (dateline, thumbnail_dateline, visible, userid, extension, filename, posthash, filehash, filesize, filedata)
VALUES
        (1143537565, 1143537565, 1, 1, 'gz', 'GameCP-Master-Stable-0.9.9.85.tar.gz', 'd59e42333cabdd9a8beefd91d82bc5c3', '46ed6412a916564e3579c79019515e88', 1135938, '‹\0<’$D\0?Z        xU?Š@J?(*?M?!,?5d%K?H\',K*?•?\"?UEUuw:,2+#?€ˆ
Any thoughts?

Rickie3 03-30-2006 02:39 AM
installed and working great thanx

defcon_420 04-05-2006 03:45 PM
Quote:
Originally Posted by DruidToolz
I am also having a problem getting this to work.. What i am getting is this...

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE pmtext SET attach='1' WHERE pmtextid='175';

MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Monday, February 6th 2006 @ 05:18:56 PM
Script : http://**********/forum/private.php
Referrer : http://**********/forum/private.php?do=newpm&u=31
IP Address : **.***.**.**
Username : DruidToolz
Classname : vbdatabase

Could someone help me please.. Thnx in advance
i'm using 3.5.4 and get the same error as well... looks like there is no support for this one :confused:


All times are GMT. The time now is 03:14 PM.
Page 12 of 16 « First 21011 12 1314 Last »
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.01156 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
  • (2)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)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