Jump to content
  • 0

Installer/Updater: Query was empty Flux


Rhaven

Question


  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  56
  • Reputation:   1
  • Joined:  11/09/12
  • Last Seen:  

fluxsqlerror4_zps9b6cd699.png

Can't install schemas.

Edited by Rhaven
Link to comment
Share on other sites

7 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  243
  • Reputation:   206
  • Joined:  11/28/11
  • Last Seen:  

Just posting this just in case someone ends up with the same error and looking for a fix:

Make sure you have all the files and their contents in fluxcp/data/schemas/charmapdb/ and fluxcp/data/schemas/logindb/. In this case, the files were in the directories but had nothing in them (perhaps from a bad upload). If you don't have them, just pull/checkout the files again or re-upload (and replace) them.

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  243
  • Reputation:   206
  • Joined:  11/28/11
  • Last Seen:  

Does the files in fluxcp/data/schemas/charmapdb/ and fluxcp/data/schemas/logindb/ allow read access?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  56
  • Reputation:   1
  • Joined:  11/09/12
  • Last Seen:  

you mean schema privileges in mysql? if that? Yes.

I checked all privileges for database ragnarok and log.

more to this. I saw that some of the tables were successfully installed but:

cp_charprefs not installed

cp_itemshop not installed

cp_redeemlog not installed

cp_xferlog not installed

cp_txnlog installed 789 but not the latest 791

the rest of the tables were installed

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  243
  • Reputation:   206
  • Joined:  11/28/11
  • Last Seen:  

Nope, not what I meant.

I have not encountered this error before, but I *think* the reason might be that the web server was not able to open and read the file. I thought it might not have the necessary read access to the files. This might be wrong now that it seems that some of the files were installed, but try to chmod -777 all the files in those two folders I mentioned above?

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  56
  • Reputation:   1
  • Joined:  11/09/12
  • Last Seen:  

Me too, I'm using your version of flux.

I'm using a free webhosting right now, just to test the site will works fine. Do you think its because of the web server? I'm not familiar with chmod -777. Or how bout if I install the tables manually to mysql? will it work? just gonna try this. I will let you know what will happen.

btw here is the screenie:

fluxinstall_zpsc6e87ba2.png

Update:

No success.

from what I can see. I can't read schemas from charmapdb. sad... I don't know what's the cause.

Edited by Rhaven
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.00
  • Content Count:  125
  • Reputation:   7
  • Joined:  11/19/11
  • Last Seen:  

same error as well, even tried in a clean db

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  308
  • Reputation:   24
  • Joined:  11/26/12
  • Last Seen:  

\data\schemas\charmapdb\index.html  <--- delete this file

\data\schemas\logindb\index.html <--- delete this file

 

After that try to update and walaaaaah!

DONE!!!

 

I found it by my self!!! ;)

Link to comment
Share on other sites

×
×
  • Create New...