WebSite X5Help Center

 
Paul R.
Paul R.
User

Issue with Database  en

Author: Paul R.
Visited 2400, Followers 2, Shared 0  

Thanks that worked managed to download app for polls now having issue with database:

1) went to settings to set up data management , and typed in description, went to one.com hosting company to find , host name, databaese name, username and password

2) went to databse on server and found datbase name, user name and password but cant see host name

  • Server: ballroomglamour.co.uk.mysql via TCP/IP
  • Software: MariaDB
  • Software version: 5.5.53-MariaDB-1~wheezy - mariadb.org binary distribution
  • Protocol version: 10
  • User: ballroomglamour_co_uk@10.27.10.48
  • Server charset: UTF-8 Unicode (utf8)

Web server

  • nginx/1.6.2
  • Database client version: libmysql - mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $
  • PHP extension: mysqli Documentation

 when i type in what i think and go back to website it will not display just get rotating circle with trying to load

Paul

Posted on the
25 ANSWERS
Andre E
Andre E
Moderator

you need to set these in x5: , host name, databaese name, username and password

step2 is not needed for x5.

remove database, create a new one. set the data in x5, upload and then it should work.

Read more
Posted on the from Andre E
Paul R.
Paul R.
User
Author

Tried that and still not displaying on preview with loading circle displaying and loading circle just displays when i try to upload and view live website

paul 

Read more
Posted on the from Paul R.
Andre E
Andre E
Moderator

I just created a new project, set a fake databes (set all fielsd to 123) created a poll filled in 123. and then it works in preview.

So it should always work in preview even when database is not filled in correctly.

Cold you try this and see what happens at your end?

Can you also test if above fails on another pc?

Read more
Posted on the from Andre E
Paul R.
Paul R.
User
Author

That worked when i set fields to 123. so must be issue with settings from host provider.

paul 

Read more
Posted on the from Paul R.
Paul R.
Paul R.
User
Author

Spoken to one come , who say that i cannot access databse externally without adding in code/script but i thought i could create a simple poll without being a web developer/programmer and writing code/ script

paul

Read more
Posted on the from Paul R.
Andre E
Andre E
Moderator

But why does it not work in your own project in preview, it should, start getting that in order, create a new page if needed. If that is correct then fill in the database information and start lookong for connection from database to one.com. But maybe it will work if you get the preview to work.

And you are right it's not hard to create a poll.

Read more
Posted on the from Andre E
Paul R.
Paul R.
User
Author

Tried new page and saving new page as php format but same issue, page header says http://127.0.0.1:8080/dance-poll.html and will not show in preview on web page as defaults to html even if i change

paul

Read more
Posted on the from Paul R.
Andre E
Andre E
Moderator

Do you use some custom code somewhere? There is something in that project because a new one works in preview.

Also something you could try: export project then import the exported project and try again

Read more
Posted on the from Andre E
Paul R.
Paul R.
User
Author

not using any code, tried to export and reimport and same issue, tried creating new datbase with host provider, question on poll displays but not the options just get timer clock?

paul

Read more
Posted on the from Paul R.
Andre E
Andre E
Moderator

Very strange, can you make some prtscrns?

Read more
Posted on the from Andre E
Paul R.
Paul R.
User
Author

Read more
Posted on the from Paul R.
Andre E
Andre E
Moderator

Is javascript installed and up to date? Else try installing javA.

it should work in preview. what if you select in preview top right a differen browser?

Read more
Posted on the from Andre E
Paul R.
Paul R.
User
Author

tried diffrent browser and still got:

Read more
Posted on the from Paul R.
Andre E
Andre E
Moderator

It is a prtscrn of x5, I need it from the preview, but first install java.

Read more
Posted on the from Andre E
Paul R.
Paul R.
User
Author

installed java , changed from google chrome to internet explorer but still same issue:

Read more
Posted on the from Paul R.
Andre E
Andre E
Moderator

Is there a firewall that can block data?

What kind of pc / operating system are you using.

Try also a brand new project, just create any database set a poll leave all data like it is in default and try again.

If it does not work send me the test project (export project in step5)

maybe flash player needs to be installed but there are discussion on internet about safety and I am not sure if it is needed. ( I have it installed anyway because I trust my firewall/ virusscanner)

Read more
Posted on the from Andre E
Paul R.
Paul R.
User
Author

yes firewall but even if i disable same issue, windows 10 pro 64 bit, tried new project same issue, project attached

paul

Read more
Posted on the from Paul R.
Andre E
Andre E
Moderator

Attachement?

I think you need flash player as well for viewing on desktop.

Read more
Posted on the from Andre E
Paul R.
Paul R.
User
Author

If i not change question or choices or pick mulitipe choice it displays

paul

Read more
Posted on the from Paul R.
Andre E
Andre E
Moderator

try online

Read more
Posted on the from Andre E
Paul R.
Paul R.
User
Author

tried online and it works and then lets me go in a change question and still displays

paul

Read more
Posted on the from Paul R.
Andre E
Andre E
Moderator

still displays means it works or not?

If not please post a websiteadress

Read more
Posted on the from Andre E
Paul R.
Paul R.
User
Author

yep works on website, does poll only allow one question as tried to create another poll or another page and same issue as before

paul

Read more
Posted on the from Paul R.
Incomedia
Claudio D.
Incomedia

Hello Paul,

Did you set another table on the other poll object?

Every object needs to use a different table to store the answers.

Many thanks!

Read more
Posted on the from Claudio D.
Andre E
Andre E
Moderator

Glad that works in the meantime....

Check out what Claudio say's, every poll needs it own databse.....

Read more
Posted on the from Andre E