WebSite X5Help Center

 
Paul R.
Paul R.
User

Issue with Database  en

Autor: Paul R.
Visited 2415, Followers 2, Udostępniony 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 ODPOWIEDZI
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.

Czytaj więcej
Posted on the from Andre E
Paul R.
Paul R.
User
Autor

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 

Czytaj więcej
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?

Czytaj więcej
Posted on the from Andre E
Paul R.
Paul R.
User
Autor

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

paul 

Czytaj więcej
Posted on the from Paul R.
Paul R.
Paul R.
User
Autor

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

Czytaj więcej
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.

Czytaj więcej
Posted on the from Andre E
Paul R.
Paul R.
User
Autor

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

Czytaj więcej
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

Czytaj więcej
Posted on the from Andre E
Paul R.
Paul R.
User
Autor

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

Czytaj więcej
Posted on the from Paul R.
Andre E
Andre E
Moderator

Very strange, can you make some prtscrns?

Czytaj więcej
Posted on the from Andre E
Paul R.
Paul R.
User
Autor

Czytaj więcej
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?

Czytaj więcej
Posted on the from Andre E
Paul R.
Paul R.
User
Autor

tried diffrent browser and still got:

Czytaj więcej
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.

Czytaj więcej
Posted on the from Andre E
Paul R.
Paul R.
User
Autor

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

Czytaj więcej
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)

Czytaj więcej
Posted on the from Andre E
Paul R.
Paul R.
User
Autor

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

paul

Czytaj więcej
Posted on the from Paul R.
Andre E
Andre E
Moderator

Attachement?

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

Czytaj więcej
Posted on the from Andre E
Paul R.
Paul R.
User
Autor

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

paul

Czytaj więcej
Posted on the from Paul R.
Andre E
Andre E
Moderator

try online

Czytaj więcej
Posted on the from Andre E
Paul R.
Paul R.
User
Autor

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

paul

Czytaj więcej
Posted on the from Paul R.
Andre E
Andre E
Moderator

still displays means it works or not?

If not please post a websiteadress

Czytaj więcej
Posted on the from Andre E
Paul R.
Paul R.
User
Autor

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

Czytaj więcej
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!

Czytaj więcej
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.....

Czytaj więcej
Posted on the from Andre E