Forums

Guestbook Database - reverts to the old database when I refresh schema

Permalink
Hi I have been trying to add a field to the Database for the guestbook, i've added the following to the db.xml in /blocks/guestbook:

<field name="user_cd" type="C" size="100">
      </field>
      <field name="user_track" type="C" size="100">
      </field>
      <field name="user_found" type="C" size="100">
      </field>
      <field name="user_left" type="C" size="100">
      </field>


But the system doesn't even seem to recognise it, i've tried clearing caches, refreshing database schema, putting the files in the root block folder and even adding the fields into the database manually (but then when the schema is refreshed it removes those fields??).

I have in the past been able to add custom fields to other blocks, is this because it is a core block it won't let you tinker or am I missing something?

Thanks

Ben
BHWW
 
12345j replied on at Permalink Reply
12345j
can you try uninstalling and then reinstalling? ive never come across this with core blocks, maybe your install is messed up.
BHWW replied on at Permalink Reply
BHWW
Hi

Thanks for your reply, unfortunately this is on a live site with a lot of data and visitors, also I have several standard guestbooks already working and used, so reinstalling isn't an option. any other ideas?

Thanks

----> OK I BACKED UP THE DATA AND TRIED REMOVING AND REINSTALLING THE BLOCK - NO SUCCESS YET
BHWW replied on at Permalink Reply
BHWW
Ok, I have this working as it should, APART FROM... when the schema is refreshed it deletes all the additional fields added, this could be a problem. any thoughts.
BHWW replied on at Permalink Reply
BHWW
Ok, this is really wierd, i've deleted the whole guestbook block from the /concrete/blocks/ directory so the only guestbook db.xml is the one that i have modified and it still reverts to the old database when I refresh schema deleting my new fields...???? any ideas!?!

Thanks
BHWW replied on at Permalink Reply
BHWW
Ok Solved it!

The guestbook blocks in updates were for some reason overriding the block in blocks... that's odd! deleted the block in the updates and voila!