Could not obtain SQL structure/data

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

Could not obtain SQL structure/data

Postby arangarx » Wed Jul 12, 2006 11:49 pm

I'm trying to get WoWRoster installed. I've created the folders needed, uploaded all the files to the server, and have a mysql database available. I've actually even gone so far as to manually load the sequal tables into the database via the .sql files provided.

The step one screen loads up fine. The installation notes say, "Roster Installer has scanned your server and determined that it meets the requirements." It says my php version is 4.4.1 and the MySQL module IS available. If it matters it says the GD module is not available. So, I click on "Start Install" and it goes to the Step Two screen.

On this screen I put in the correct information, then I get one of two errors:
(error 1)
It moves to Step Three screen and says:
Failed to connect to database XXXXX as XXXXX@localhost.
Restart Installation?

(error 2)
It goes to a white screen with the text:
Could not obtain SQL structure/data

I think the first one might have more to do with the stability of the server or something, because I seem to get the second error more often. But when I don't get the first error I get the second error. Another kid seemed to have the same problem in another forum, but hadn't gotten any responses.
Forum Entry

For the sake of ease I'll repeat his code snippets here. In the install.php file there are two areas that give the kill(Could not obtain SQL structure/data) command.

Code: Select all
function remove_remarks($sql)
{
    if ( 
$sql == '' )
    {
        die(
'Could not obtain SQL structure/data');
    }
 


Code: Select all
function parse_sql($sql$delim)
{
    if ( 
$sql == '' )
    {
        die(
'Could not obtain SQL structure/data');
    }
 


This other kid determined that the problem had to do with the first part, by using a print command just before each kill statement.

I went in to the install.php file and tried to see what would happen if I remove the "remove remarks" function. Interestingly enough, I get neither of the above mentioned errors. It goes to either a DNS error or a 404 type page as if it is trying to go to a site that doesn't exist. This still happens after step two.

Has anyone else seen this? Or can you point me in the right direction? I'd appreciate any help I can get. Thanks.

Arangarx
arangarx
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Wed Jul 12, 2006 4:56 am

Could not obtain SQL structure/data

Postby Slyver » Thu Jul 13, 2006 12:29 am

Did you already create the database and username before hand? If you did have you looked at the database to see if the tables have been created? If the tables are created has anything been updated in them at all?

You can also try deleting the tables you created from the .sql files because the installation will do all that for you.
Slyver
WR.net Apprentice
WR.net Apprentice
 
Posts: 31
Joined: Tue Jul 11, 2006 10:27 pm

Could not obtain SQL structure/data

Postby mareynn » Thu Aug 03, 2006 6:14 am

I am getting the exact same problem. I have a ticket open with my ISP because I have created a practice database and wrote my own script to access the data and am having issues with connecting to the database. Wondering if the two problems are connected due to a server setting. Will post again when i hear from the ISP.

@Slyver - in my case (and probably arangarx too if i read him/her correctly) I started with a database which had no structure, tables, data and also received this message. Consequently used the install .sql files to supply the structure and default data. Sadly, the same error message.
mareynn
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Mon Jul 31, 2006 6:36 am

Could not obtain SQL structure/data

Postby mareynn » Fri Aug 04, 2006 4:28 pm

Solution was simple in the end. The "/install/db/mysql_structure.sql" file was missing from the directory. Once i put in place it installed fine. :)
mareynn
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Mon Jul 31, 2006 6:36 am

Could not obtain SQL structure/data

Postby funkyjelly » Tue Sep 19, 2006 10:50 pm

not that simple for me any other suggestions?

I have all in place ran a custom script to subroutine the sql side of things,

just looking for a fix,
Last edited by funkyjelly on Wed Sep 20, 2006 2:15 am, edited 1 time in total.
funkyjelly
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Tue Sep 19, 2006 4:33 am


Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 1 guest

cron