mysql upgrade script not working?

Question

Below is the my config.xml file

<resources>
                <categoryrestrict_setup>
                    <setup>
                        <module>Exinent_Categoryrestrict</module>
                        <class>Mage_Catalog_Model_Resource_Setup</class>
                    </setup>
                    <connection>
                        <use>core_setup</use>
                    </connection>
                </categoryrestrict_setup>
                <categoryrestrict_write>
                    <connection>
                        <use>core_write</use>
                    </connection>
                </categoryrestrict_write>
                <categoryrestrict_read>
                    <connection>
                        <use>core_read</use>
                    </connection>
                </categoryrestrict_read>
            </resources>

and my upgrade file name is upgrade-1.0.0-1.0.1.php but it is not working

<modules> <Exinent_Categoryrestrict> <version>1.0.1</version> </Exinent_Categoryrestrict> </modules> — Pawankumar
– Pawankumar, Commented Apr 23, 2015 at 7:49
i think your mysql install file name from the sql/categoryrestrict_setup is mysql4-install-1.0.0.php . m i right — Pradeep Sanku
– Pradeep Sanku, Commented Apr 23, 2015 at 7:52
please check core_resource table under categoryrestrict_setup what is the version number their ? — Pradeep Sanku
– Pradeep Sanku, Commented Apr 23, 2015 at 7:53

Pradeep Sanku · Accepted Answer · 2015-04-23 07:04:08Z

2

or just check your config.xml line should be something like this

<modules>
    <YourPackageName_YourModuleName>
        <version>1.0.1</version>
    </YourPackageName_YourModuleName>
</modules>

answered Apr 23, 2015 at 7:04

Pradeep Sanku

9,2662 gold badges42 silver badges75 bronze badges

Add a comment |

Laura · Accepted Answer · 2015-08-13 22:04:19Z

1

Please be sure that you have increased the version in your config.xml, you need something like this:

<modules>
    <YOURNAMESPACE_YOUREXTENSIONNAME>
        <version>1.0.1</version>
    </YOURNAMESPACE_YOUREXTENSIONNAME>
</modules>
<global>
    <resources>

After debugging the script be sure that your setup version is one before in the database. To run it again, you can find and change the version in the table core_resource.

edited Aug 13, 2015 at 22:04

Laura

2,7192 gold badges28 silver badges52 bronze badges

answered Apr 23, 2015 at 7:03

andreasemer

214 bronze badges

Just add one more point that you need to give full permission to your /var/www/your-project/app/code/local/YOURPACKAGE/sql folder also.

apandey846
– apandey846

2016-01-18 11:14:08 +00:00
Commented Jan 18, 2016 at 11:14

Add a comment |

Stack Exchange Network

mysql upgrade script not working?

2 Answers 2

Your Answer

Hot Network Questions

mysql upgrade script not working?

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions