Issue with Database
Auteur : Paul R.
Visité 2703,
Followers 2,
Partagé 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
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
Posté le
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.
Auteur
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
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?
Auteur
That worked when i set fields to 123. so must be issue with settings from host provider.
paul
Auteur
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
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.
Auteur
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
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
Auteur
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
Very strange, can you make some prtscrns?
Auteur
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?
Auteur
tried diffrent browser and still got:
It is a prtscrn of x5, I need it from the preview, but first install java.
Auteur
installed java , changed from google chrome to internet explorer but still same issue:
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)
Auteur
yes firewall but even if i disable same issue, windows 10 pro 64 bit, tried new project same issue, project attached
paul
Attachement?
I think you need flash player as well for viewing on desktop.
Auteur
If i not change question or choices or pick mulitipe choice it displays
paul
try online
Auteur
tried online and it works and then lets me go in a change question and still displays
paul
still displays means it works or not?
If not please post a websiteadress
Auteur
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
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!
Glad that works in the meantime....
Check out what Claudio say's, every poll needs it own databse.....