Jump to content


Photo

When installing get php error that 'row' is not defined


  • Please log in to reply
5 replies to this topic

#1 tmo

tmo

    Newbie

  • New Members
  • Pip
  • 2 posts

Posted 31 December 2012 - 11:23 PM

PHP notice

Undefined variable: row



/var/www/html/zurmo/app/protected/modules/zurmo/utils/ZurmoDatabaseCompatibilityUtil.php(1688)



1676 if (RedBeanDatabase::getDatabaseType() == 'mysql')
1677 {
1678 try
1679 {
1680 $rows = R::getAll("select routine_name, routine_type from information_schema.routines;");
1681 foreach ($rows as $row)
1682 {
1683 R::exec("drop {$row['routine_type']} if exists {$row['routine_name']}");
1684 }
1685 }
1686 catch (Exception $e)
1687 {
1688 echo "Failed to drop {$row['routine_type']} {$row['routine_name']}.\n";
1689 throw $e;
1690 }
1691 if (YII_DEBUG)
1692 {
1693 R::exec("drop procedure if exists write_log");
1694 }
1695 }
1696 else
1697 {
1698 throw new NotSupportedException();
1699 }
1700 }





#2 Jason

Jason

    Administrator

  • Administrators
  • 864 posts
  • LocationChicago

Posted 01 January 2013 - 01:55 AM

Seems like you have a permissions issue with the mysql user. It is missing permissions to add/remove routines/functions.

Jason Green
Zurmo Team
Need support? Upgrade now


#3 tmo

tmo

    Newbie

  • New Members
  • Pip
  • 2 posts

Posted 01 January 2013 - 03:24 AM

Tried a couple of things but appears that is not helping. Is there a sql script to create the database and tables.

#4 Ivica

Ivica

    Advanced Member

  • Moderators
  • 565 posts

Posted 02 January 2013 - 09:44 AM

No, it is all done automatically based on Zurmo models' members and rules, using RedBeanPHP ORM.

It look like permission error, when creatating/deleting mysql routines, so you need probably to alter privileges of your mysql user, and try installation again.

#5 Dan

Dan

    Newbie

  • New Members
  • Pip
  • 7 posts

Posted 15 January 2013 - 03:27 AM

After some research I was able to uncover my underlying issue which was this error...

 

RedBean_Exception_SQL message SQLSTATE[HY000]: General error: 1548 Cannot load from mysql.proc. The table is probably corrupted

 

On the surface it was the same error as described in this post.

 

My instance of MySQL had a corrupted information schema table called routines.  I needed to run the mysql_upgrade command.

 

Hope this helps,

Dan



#6 Jason

Jason

    Administrator

  • Administrators
  • 864 posts
  • LocationChicago

Posted 15 January 2013 - 02:42 PM

Ok keep us posted.


Jason Green
Zurmo Team
Need support? Upgrade now





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users