vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3 Articles (https://vborg.vbsupport.ru/forumdisplay.php?f=187)
-   -   vBulletin and mySQL (https://vborg.vbsupport.ru/showthread.php?t=75207)

White_Snake 09-06-2005 11:20 PM

this one would be great for vB 3.5.0

Brad 09-13-2005 06:28 AM

Quote:

Originally Posted by White_Snake
this one would be great for vB 3.5.0

Data management has changed a bit in vB 3.5, there are a lot of new options offered. I plan on doing one of these for 3.5 but I will wait until gold is out as the code should be more stable then, there are still a few things in the 3.5 code that may change or have things added (see class_dbalter.php for a good example of that :)).

White_Snake 09-13-2005 05:41 PM

Quote:

Originally Posted by Brad
Data management has changed a bit in vB 3.5, there are a lot of new options offered. I plan on doing one of these for 3.5 but I will wait until gold is out as the code should be more stable then, there are still a few things in the 3.5 code that may change or have things added (see class_dbalter.php for a good example of that :)).

0ka i will chech that, thanks for the info :)

HaMaDa4eVeR 01-23-2006 10:28 AM

nice topic
I've some questions
- How do I creat new table with 2 felds , sure with vBulletin functions and classes
example:-
PHP Code:

CREATE TABLE `mytable` (
`
field1TEXT NOT NULL ,
`
field2TEXT NOT NULL 
TYPE MYISAM 

- Add data into fields there
- read the data from the fields there
REMEMBER I knew the answer of all questions in PHP-MySQL syntax but i want to know in vBulletin classes and function , because I want to use it in my [Product] for vB 3.5
thanks :)

bobdell01 06-05-2007 02:40 PM

This has been driving me nuts for a couple hours...

It seems that $db->fetch_array($result) returns an associative array by default.

To return both an associative and numerically indexed array, use a result type of 0.

eg: $db->fetch_array($result,0)

G00SE9 08-15-2007 11:32 PM

We keep getting this error from vb 3.6.7pl1. Our host is half way around the world (not the best setup, but it was cheap...maybe we know why now....), which I'm sure isn't helping things, but this is really driving me crazy. We receive this at least 15-20 times/day.
We have less than 100 members and normally, no more than 25 logged in. Vbulletin has not
been modded extensively, except for a shoutbox, anonymizer, and vbimagehost.
The database is approximately 17MB at this time.
===============================================
Database error in vBulletin :

The first is a mysql_connect, the second is a mysql_pconnect; we receive both.

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/customersn/http_docs/forum/includes/class_core.php on line 274

OR:

mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/customersn/http_docs/forum/includes/class_core.php on line 274

(3 different sources of the errors are shown here)

MySQL Error :
Error Number :
Date : Thursday, August 16th 2007 @ 12:37:16 AM

Script : http://www.customersnw.com/forum/vbshout.php
Referrer : http://www.customersnw.com/forum/index.php

Script : http://www.customersnw.com/forum/login.php?do=login
Referrer : http://www.customersnw.com/forum/showthread.php?t=821

Script : http://customersnw.com/forum/search.php?searchid=8541
Referrer : http://customersnw.com/forum/index.php

IP Address : 2XX.X5.1X9.X8
Username :
Classname : vB_Database
================================================== ==
This is my first vb installation and "administration".....I'm totally lost here. But every error
is exactly the same regarding all the information in the actual error message ( mysql error message at the beginning of this post (can't connect or pconnect..../var/lib/mysql/mysql.sock).
And, our actual domain name IS NOT www.customersnw.com, it's customersnw.com.
One other thing of significance is that the database was imported from a phpbb 2.x site.
We have had the hosting company check the my.cnf file and supposedly the file contents are correct & the path to mysql.sock is correct.
A client section was also added: [client]
socket=/var/lib/mysql/mysql.sock


Any comments or constructive suggestions regarding this error would be appreciated.
Thank you.

powerful_rogue 06-02-2009 09:35 AM

Am I right in presuming this article is still valid with 3.8?


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01311 seconds
  • Memory Usage 1,737KB
  • 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_php_printable
  • (2)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
  • (7)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