vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - cURL (https://vborg.vbsupport.ru/showthread.php?t=199570)

theorigin

12-23-2008 01:00 AM

cURL

I just tried installing the gWoWRoster hack, but it said it requires cURL to run. This is the first time I've come across this, so I'm not exactly sure how to go about adding it seamlessly. Is it a simple upload, or does it have to be customized? Any help would greatly be appreciated.

Deceptor

12-23-2008 01:01 AM

Needs to be enabled when compiling php. Best to check with your host if you have it installed, and if not can they install it.

theorigin

12-23-2008 01:45 AM

I checked on godaddy and it said that cURL is supported with the server type that I have, but for some odd reason, this is the error that I keep receiving every time I try and upload that particular WoW file:

Code:

Database error in vBulletin 3.7.2:



Invalid SQL:



        CREATE TABLE IF NOT EXISTS gwowroster_charinfo_prof (

                `locale` VARCHAR( 2 ) NOT NULL ,

                `realm` VARCHAR( 100 ) NOT NULL ,

                `name` VARCHAR( 100 ) NOT NULL ,

                `charname` VARCHAR( 100 ) NOT NULL ,

                `key` VARCHAR( 100 ) NOT NULL ,

                `updated` INT( 255 ) NOT NULL ,

                `primary` INT( 1 ) NOT NULL ,

                `profname` VARCHAR( 100 ) NOT NULL ,

                `max` INT( 10 ) NOT NULL ,

                `value` INT( 10 ) NOT NULL ,

                PRIMARY KEY ( `locale`, `realm`, `name`, `charname`, `key` )

        );



MySQL Error   : Specified key was too long; max key length is 1000 bytes

Error Number  : 1071

Request Date  : Monday

Could it be because I'm running MySQL 4?

Deceptor

12-23-2008 01:56 AM

It could possibly be with MySQL 4, I remember there used to be a bug with MySQL concerning key length, but I'm not too sure what the problems were exactly. You could try change the last line of that query to:

Code:

PRIMARY KEY ( `locale` )

There should only be one primary key in a table.

theorigin

12-23-2008 02:01 AM

What's the easiest way to go about doing that? The only thing I did was upload that particular file through Products and that's when it gave me that error.

Deceptor

12-23-2008 02:02 AM

Open the xml file.
Search for:

Code:

PRIMARY KEY ( `locale`, `realm`, `name`, `charname`, `key` )

Replace with:

Code:

PRIMARY KEY ( `locale` )

If you're not sure how to open the XML file, tell windows to use Notepad.

Save then try again :)

Dismounted

12-23-2008 02:09 AM

You might want to ask the author of the modification to fix this issue. There should really be only one primary key per table.

theorigin

12-23-2008 02:20 AM

Thanks! That at least made it go through. Now the only problem is that after I followed the installation for the rest of the hack, the information doesn't show up after I set it up. I ran the Scheduled Task Manager to update it, but it didn't seem to do anything.

Although now that I just checked on it, every time I update the profile field ID and save it, it reverts back to the original. Could that be because I took that information out in the primary key?

I will also post this in the hack thread itself..thanks for the help.

Marco van Herwaarden

12-23-2008 09:47 AM

You should not just go make changes to the database and expect things to still work. Please ask the author of the modification.

All times are GMT. The time now is 04:43 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01276 seconds Memory Usage 1,735KB 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 (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: