WebSite X5Help Center

 
Paul R.
Paul R.
User

Issue with Database  en

Автор: Paul R.
Просмотрено 2693, Подписчики 2, Размещенный 0  
Тэги: database,issue,with

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

Размещено
25 Ответы
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.

Читать больше
Размещено От Andre E
Paul R.
Paul R.
User
Автор

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 

Читать больше
Размещено От 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?

Читать больше
Размещено От Andre E
Paul R.
Paul R.
User
Автор

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

paul 

Читать больше
Размещено От Paul R.
Paul R.
Paul R.
User
Автор

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

Читать больше
Размещено От 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.

Читать больше
Размещено От Andre E
Paul R.
Paul R.
User
Автор

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

Читать больше
Размещено От 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

Читать больше
Размещено От Andre E
Paul R.
Paul R.
User
Автор

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

Читать больше
Размещено От Paul R.
Andre E
Andre E
Moderator

Very strange, can you make some prtscrns?

Читать больше
Размещено От Andre E
Paul R.
Paul R.
User
Автор

Читать больше
Размещено От 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?

Читать больше
Размещено От Andre E
Paul R.
Paul R.
User
Автор

tried diffrent browser and still got:

Читать больше
Размещено От Paul R.
Andre E
Andre E
Moderator

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

Читать больше
Размещено От Andre E
Paul R.
Paul R.
User
Автор

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

Читать больше
Размещено От 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)

Читать больше
Размещено От Andre E
Paul R.
Paul R.
User
Автор

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

paul

Читать больше
Размещено От Paul R.
Andre E
Andre E
Moderator

Attachement?

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

Читать больше
Размещено От Andre E
Paul R.
Paul R.
User
Автор

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

paul

Читать больше
Размещено От Paul R.
Andre E
Andre E
Moderator

try online

Читать больше
Размещено От Andre E
Paul R.
Paul R.
User
Автор

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

paul

Читать больше
Размещено От Paul R.
Andre E
Andre E
Moderator

still displays means it works or not?

If not please post a websiteadress

Читать больше
Размещено От Andre E
Paul R.
Paul R.
User
Автор

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

Читать больше
Размещено От 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!

Читать больше
Размещено От 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.....

Читать больше
Размещено От Andre E