Unable To Save Data In MySQL From A Custom Magento Module

Question

I am making a custom module for Magento 1.7.0. I am facing a problem while trying to insert data into MySQL. I fetch the user information from the session as follows:

$customer = Mage::getSingleton('customer/session')->getCustomer(); 
$user_id = $customer->getId();

$user_id now carries ID of the current user logged into my Magento system.

Basically the problem is that when I try to save this above ID in my custom table, the value that is saved in my table is always 0.

Previously I faced this problem while trying to save another integer value, which I solved by changing the datatype of my MySQL table column from int(10) to tinyint(4), but in this case I cannot do so for the user ID.

$model= Mage::getModel('voter/competetion')
    ->setDesignid($designId)
    ->setUserId($user_id)
    ->setVote($vote)
    ->setStartdate($startDate)
    ->save();

The MySQL column name are as follows along with the install sql script: id, designid, user_id, vote, startdate, enddate

$installer = $this;
$installer->startSetup();

$prefix = Mage::getConfig()->getTablePrefix();

$installer->run("
    CREATE TABLE IF NOT EXISTS ".$prefix."vote_competetion (
        id int(10) NOT NULL AUTO_INCREMENT,
        designid int(10) NOT NULL,
        user_id int(10) NOT NULL,
        vote tinyint(1) NOT NULL,
        startdate datetime NOT NULL,
        enddate datetime NOT NULL,
        PRIMARY KEY (id),
        FOREIGN KEY (designid) REFERENCES ".$prefix."vote_design(id)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
");

Mage::getModel('core/url_rewrite')->setId(null);
$installer->endSetup();

Is there something wrong with my setter method name. All other values are being saved correctly. I am really not sure what to do about this. Please help.

I appreciate all the help.

Thanks!

Emi · Accepted Answer · 2012-05-30 13:28:02Z

3

If you didn't have user_id in the table from the start, you should clear the cache since Magento keeps it's structure cached and will not set any new columns data.

answered May 30, 2012 at 13:28

Emi

1,0189 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rahul tripathi Over a year ago

Thanks, this is the perfect answer! I'd appreciate it!

Roman Snitko · Accepted Answer · 2012-05-30 12:25:14Z

0

You have an error in naming of user id field. In table it is named as userid, so in your code you should call it like this:

$model= Mage::getModel('voter/competetion')
    ->setDesignid($designId)
    ->setUserid($user_id) // notice lowercase "i" here
    ->setVote($vote)
    ->setStartdate($startDate)
    ->save();

Or you can rename field in table from userid to user_id.

answered May 30, 2012 at 12:25

Roman Snitko

3,64527 silver badges29 bronze badges

2 Comments

rahul tripathi Over a year ago

That's my bad, I made a mistake while pasting the SQL in the question. The column name in phpMyAdmin is actually user_id. I've edited the question.

rahul tripathi Over a year ago

It is still not working and the problem persists. Thanks for the answer.

Collectives™ on Stack Overflow

Unable To Save Data In MySQL From A Custom Magento Module

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related