Welcome, Guest
Username: Password: Remember me

TOPIC: [SOLVED] No Data Tables?

No Data Tables? 01 Nov 2014 17:53 #12726

  • rholzler
  • rholzler's Avatar
  • Offline
  • Junior Member
  • Posts: 30
  • Thank you received: 1
  • Karma: 0
I am installing my component and getting:

500 Error Table ' ' doesn't exist

I checked the database and the tables are not there. Any ideas?
The administrator has disabled public write access.

No Data Tables? 03 Nov 2014 10:57 #12727

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
It might be at the install, the SQL script had an error.

Is it working in the sandbox ?
Can I have a look please ? Wich project ?
Coding is now a piece of cake
Last Edit: 03 Nov 2014 10:59 by admin.
The administrator has disabled public write access.

No Data Tables? 03 Nov 2014 11:50 #12728

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
I think I have found.

It depends if it is the same problem I think.
Is the version of you project undefined ?

Because, after the last upgrade, I have added a feature to put SQL for incremental patchs in the sql / update directory.
There was a bug when the project has empty version. It should be fixed now.

If your problem is not related to that, please precise the project and I will check.
Coding is now a piece of cake
The administrator has disabled public write access.
The following user(s) said Thank You: rholzler

No Data Tables? 03 Nov 2014 23:46 #12738

  • rholzler
  • rholzler's Avatar
  • Offline
  • Junior Member
  • Posts: 30
  • Thank you received: 1
  • Karma: 0
I managed to track down the source of the problem. When I install an updated version of the component, it does not add new tables or fields to the database. I have a substantial amount of data that I need to preserver, so I manually added the new fields and tables to resolve the problem.
The administrator has disabled public write access.

No Data Tables? 04 Nov 2014 10:01 #12739

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
Ok. This is normal.

Take note that now is available a new feature for that.
You can recreate the table structure after an update :
se here : www.j-cook.pro/index.php/docs/versions/197-2-6-5

In your case, if you want to keep the datas, then it is better to adjust the stucture manually, as you did.

I am glad you got it sorted.
Coding is now a piece of cake
The administrator has disabled public write access.
Time to create page: 0.068 seconds

Get Started