Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Build 554 of SampleNuFinancial install has read-only error

Locked
JohnKlassen
Posts: 148
Joined: Wed Dec 05, 2012 4:56 am

Build 554 of SampleNuFinancial install has read-only error

Unread post by JohnKlassen »

Hi,

Recently I upgraded to NuBuilder Build 554 (version 2.8.1). I assumed that with a new build, samplenufinancial needed to be dropped and reloaded. I dropped all the tables but not the database. I then tried to reload the tables by importing the samplenufinancial.sql script and having it skip the first 3 lines. I keep getting an error that "#1036 - Table 'zzsys_image' is read only'. Here are the details.
Error

SQL query:

-- -- Dumping data for table `zzsys_image` -- INSERT INTO `zzsys_image` (`zzsys_image_id`, `sim_code`, `sim_description`, `sim_group`, `sim_blob`, `sys_added`, `sys_changed`, `sys_user_id`) VALUES ('149bf07777e6a0', '001', 'Index', 'System', 0x89504e470d0a1a0a0000000d49484452000003d800000046080600000037ae3cdf000010d84944415478daeddd5b6c1cd77dc7f1ffcc72b9bc89a24831b21552b5285b1787a914b854dcc8aeedb8956b57a90a092d02b4901154410b243290b6560ba728da0717aef560c0561f0a0808ac0286db406c153868ecb48e8b38802202d6c5746d3189225b546d55224553bc682f33d3396766766797bbdc0b975c72f5fdc0e3dd9d999d9d5d3efdf43fe77f0cc72500000000006041cc5adf000000000000f580800d00000000401510b00100000000a802023600000000005540c00600000000a00a08d8000000006a22f1ee1b121f3424353c98de675d3e2bc91f1f96c47f1f16fbc668ad6f11284b43ad6f00000000c0edc93045cc36f74924b3cff9f4a298d6117152ee8be4c15adf22501602360000008045678d8d4aea47bd62ae7b5aa20f3eaff7453fb75be4734ed6794ea4cd3d573d7103b853c107013544c006000000b0240c55a92e324935bacd0ddddbb29375e23[...]

MySQL said:
#1036 - Table 'zzsys_image' is read only
I realize now that I probably should have left samplenufinancial alone. What do I need to do to get samplenufinancial working again?

Thanks,

John
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: Build 554 of SampleNuFinancial install has read-only err

Unread post by admin »

John,

I'm not sure.

This might help..

http://mysql.livejournal.com/113300.html

Steven
JohnKlassen
Posts: 148
Joined: Wed Dec 05, 2012 4:56 am

Re: Build 554 of SampleNuFinancial install has read-only err

Unread post by JohnKlassen »

Steven,

I dropped the samplenufinancial database, commented out the first 4 lines of the samplenufinancial.sql script and then imported it again. This time it worked!

I did check the the link you had in your post. Most of it is geared to UNIX permissions and since I am using Windows, only some of the information was useful.

Thanks,

John
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: Build 554 of SampleNuFinancial install has read-only err

Unread post by admin »

Cool
Locked