Hello Jim,

This is not hard, it sounds worse then it is to get it working.

The folder you don't need.

You do need to set a databse at your host, as I understand you know how to do that.

You have localhost all set and so on, what's importand is that the database you use, is only used once, so only for 1 item in x5, nothing more.

So you created an empty database, you filled in the information.

Then set the name in the name in the oll object, and select the databse.

Then set your questions and all the rest in the poll object.

Then upload and check online.

That's it.

But it does not work I see and you followed all steps.

you don't need to connect to the databse using SQL, this does x5 all for  you.

If it does not work, remove databse, make a new one, add this and try again.

It's importand that the name password, adress and so on from the database are correct.

Hi Andre E,

Thank you for your usual prompt response, I have removed the existing database as suggested by you and created a new database, however as I have no experience of creating databases, I may not have done it correctly, if so please bear with me.

See attached jpeg:

1. Server: localhost Database: cl56-jimc Table: Poll
2. Set up database ??????????
3. Data Management set up in X5
4. Poll set up in X5
5. Online error message when trying to use the Poll Object.

I suspect that I may be doing something wrong with the database set up, but what I don’t know. If this is the case I would probably need step-by-step instructions, or if possible, a working example of the database set up. I  can usually figure things out from a working example.

I certainly appreciate any help that you can provide me and thank you for your time and patience.

Jim

Hola la el procedimiento es correcto salvo el crear la tabla, deje la base de datos en blanco no añada ninguna tabla, esta misma la crea website x5 en Data Saving alli se escribe el nombre de la tabla

Hi Henry H,

Hola la el procedimiento es correcto salvo el crear la tabla, deje la base de datos en blanco no añada ninguna tabla, esta misma la crea website x5 en Data Saving alli se escribe el nombre de la table

Google translate:

Hello the procedure is correct except to create the table, leave the database blank do not add any table, this is created by website x5 in Data Saving there is written the name of the table.

Google translate:

Gracias por sus comentarios, he intentado dejar la base de datos en blanco como sugirió, sin embargo, X5 insiste en que se ingresen estos datos, que se obtienen de la sección Administración de datos en Configuración avanzada. X5 no le permitirá avanzar si los campos de guardado de datos están en blanco.

Pido disculpas si he entendido mal sus comentarios traducidos por Google.

Thank you for your feedback, I have tried leaving the database blank as you have suggested, however X5 insists that this data is entered, which it gets from the Data Management section in Advanced Settings. X5 will not allow you to progress if the data saving fields are blank.

I apologise if I have misunderstood your feedback translated by Google.

Jim

Hi Andre E,

Finally got it to work OK, I was making two errors:

1.Instead of just creating a database on the server, I was also creating the table, however you don’t need to do     that as X5 creates it for you.

2.When I initially set up the database on the server, I had to give a user name and password, the database then   created a user name database of cl56-jimc

When I was setting up the details in Data Management in X5, I was using the initial user name that I gave to set up the database on the server rather than the created user name database of cl56-jimc see below:

There is one other issue that I have noticed, when you place the cursor over the bar chart a box appears see below, but only shows four letters out of the five, E is cut off.

The website is at www.jimcosgrove.co.uk

Once again many thanks for all your help and support.

Jim

Great,
I had a feeling the user name was not from database but i good not see that offcource, that's why i posted to use this from databse.

And Henry stated that table is not needed as well.

Anyway, thanks for the feedback again, and glad it works now.

Best regards.

Hi Henry H,

Thank you for your feedback, I apologise, as I did not fully understand what you were telling me. I did do as you suggested and left the database blank, but it still did not work but that was due to me using the wrong user name.

Instead of just creating a database on the server, I was also creating the table, however you don’t need to do that as X5 creates it for you as you quite rightly said.

When I initially set up the database on the server, I had to give a user name and password, the database then created a user name database of cl56-jimc.

When I was setting up the details in Data Management in X5, I was using the initial user name that I gave to set up the database on the server rather than the created user name database of cl56-jimc.

Thank you for your help.

Jim.

Google translate:

Gracias por sus comentarios, me disculpo, ya que no entendí completamente lo que me estaba diciendo.Hice lo que me sugirió y dejé la base de datos en blanco, pero aún así no funcionó, pero se debió a que usé el nombre de usuario incorrecto.

En lugar de solo crear una base de datos en el servidor, también estaba creando la tabla, sin embargo, no es necesario que lo haga, ya que X5 la crea para usted como lo ha dicho correctamente.
Cuando configuré inicialmente la base de datos en el servidor, tuve que dar un nombre de usuario y contraseña, luego la base de datos creó una base de datos de nombres de usuario de cl56-jimc.
Cuando estaba configurando los detalles en Data Management en X5, estaba usando el nombre de usuario inicial que le di para configurar la base de datos en el servidor en lugar de la base de datos de nombres de usuario creada de cl56-jimc.

Gracias por tu ayuda.

Jim.