24 replies to this topic

[Cris D.]

The SQL error above does not even come close to matching the first one. If we are going to help de-bug, you will need to be very particular about what you change.

The first one is pointing to table etomite_etogal_shop_01 and the second is etomite_etogal_egExtender
The first's columns are: Color, Price, lable3, lable4, lable5, lable6 the second is lable1, lable2, lable3, lable4, lable5, lable6 So I'm guessing your snippet call has also changes from the first to the second.

It is too hard to diagnose when so many changes are being made at once, and if it then works, no-one knows what it was that fixed it. Errors like this can be caused by a single stray comma or missing space etc, so detail is important.

As Ralph asked earlier... Is this an etomite error message?

[doolB]

Ok sorry, I will try to be precise.

Since my first post I have changed the call back to using the default table (egExtender) and the default labels. In my first try i made some changes, but since that didn't work I changed every thing back to default. (as found in the example)
I have not made any changes to the script at all. In the call I have removed "tableName=your_table_name". I have looked in SQL database for the tabels but I found neighter etomite_etogal_shop_01 or etomite_etogal_egExtender
In the database I found a table named etomite_etogal, so I guess that the EtoGal is working fine. (I know it is)


My call

[!EGextender?colnames=lable1,lable2,lable3,lable4,lable5,lable6!]

This is the full error massage when I am Loged in.

« Error »
Etomite encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed »
SQL: CREATE TABLE`etomite_etogal_egExtender`(`ai` INT(100) NOT NULL AUTO_INCREMENT,`id` INT(100) NOT NULL,`lable1` VARCHAR (100),`lable2` VARCHAR (100),`lable3` VARCHAR (100),`lable4` VARCHAR (100),`lable5` VARCHAR (100),`lable6` VARCHAR (100),PRIMARY KEY (`ai`),UNIQUE (`id`)) TYPE=myisam;

And the error massage when I am not Loged in.

« Error »
Etomite encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed »
SQL: SELECT * FROM `web297763`.etomite_etogal_egExtender WHERE id=1 ;

[Cris D.]

OK, I just copied and pasted the SQL code above directly into phpMyAdmin into the SQL query section and it worked perfectly. I'm thinking that this is a database version issue.

1) Please provide your stats for:
php version,
SQL version,
PHPMyAdmin version,
Etomite version
Server type

2) Please attempt to create the table by copying and pasting the following code directly into your database:

CREATE TABLE`etomite_etogal_egExtender`(`ai` INT(100) NOT NULL AUTO_INCREMENT,`id` INT(100) NOT NULL,`lable1` VARCHAR (100),`lable2` VARCHAR (100),`lable3` VARCHAR (100),`lable4` VARCHAR (100),`lable5` VARCHAR (100),`lable6` VARCHAR (100),PRIMARY KEY (`ai`),UNIQUE (`id`)) TYPE=myisam;

and let me know if it was successfully created. If not, what was the error? This will determine whether it is a database issue or an etomite issue.

[Ralph]

doolB, you can get all of the information CrisD asked for, which is usually standard procedure earlier on than this, by going to Etomite Manager > System info > Server information > PHP info: View... Look in the appropriate sections for the information requested... Some software combinations just have a hard time running CREATE TABLE scripts from within Etomite and it could be for any of several reasons ranging from MySQL user rights to PHP version release quirks...

[doolB]

Hi,

I really appreciate your help, Thanks.

1)
php version, 5.2.6
SQL version, Client API version - 5.0.51a
PHPMyAdmin version, 2.11.7.1
Etomite version, 1.1 Prelude
Server type, Apache 2.0 Handler

2)
I managed to run the SQL code as you suggested. It was a success. ;-)
Now it looks like that the Extender is working to some extension. (the default labels are not very useful)

I have trouble with the “manage file” function in Etomite. (but that I will fix later, I hope)
I have just installed PoMMo in a sub dir on the same server and the table creation went well. But I was running php in safe mode and I had to manually create the dir for PoMMo installation.

I don’t know if there is any relation between this and the SQL error.

Thomas N

[Ralph]

Linux or Windows server OS...???

[doolB]

Ralph, on Mar 14 2009, 03:55 PM, said:

Linux or Windows server OS...???

Linux. (I think)
I am hosting my page at a webhotel, www.web10.dk. The site name is www.lystsind.dk if you can use that for anything.
So i really dont have a lot of control over the software versions.

[Ralph]

doolB, on Mar 14 2009, 10:16 AM, said:

Linux. (I think)
I am hosting my page at a webhotel, www.web10.dk. The site name is www.lystsind.dk if you can use that for anything.
So i really dont have a lot of control over the software versions.

phpinfo tells the server OS in the very top section, as well as in one or two other places as I recall...

Your server is running FreeBSD which is a flavor of Unix...

[Cris D.]

I really don't know exactly what the issue is with CREATE table and your settings without doing some testing in your environment- something I'm not keen to do. I do remember having some issues with gettting the SQL to run when I created the snippet, but I don't remember why or what I did to fix it (something about SQL syntax just doesn't get passed on through the etomite parser sometimes). At the end of the day, you were able to get your table created and move forward, lets go from there.

To change the lables, you will need to change (rename, add or delete) the columns in your table using PHPMyAdmin. Don't touch the 'id' or 'ia' columns. When you have your fields the way you want them, simply add them to the snippet call so it knows what to display and where to save the changes to and you are in busiess.

Fo help with the "Manage Images" button, that is a question for the etogal thread.

[doolB]

Well, i am greatful for you time.
I don't mind some manual work. So thanks for the solution and help.

Thomas N