doesn't existDatabase access error on Ray tables

I keep on getting the below email. I checked on the phpMyadmin the table name is there though all in lowered letters. The temporary remedy I did was drop and create the table with the table name it wants. I'm not sure if this will affect some queries in the future.

I also checked the d7 sql install file and all Ray table name are caps and lowers. Something might happened during the installation or is it a bug?

Database access error. Description: Table 'xxx_cm.RayVideo_commentsFiles' doesn't existDatabase access error. Description: Table 'xxx_cm.RayVideo_commentsFiles' doesn't exist<br />
<b>Warning</b>: mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/home/xxx/public_html/flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php</b> on line <b>67</b><br />
Quote · 28 Jun 2010

Hello execute this mysql query :


--
-- Table structure for table `RayVideo_commentsFiles`
--

CREATE TABLE `RayVideo_commentsFiles` (
`ID` int(11) NOT NULL auto_increment,
`Categories` text NOT NULL,
`Title` varchar(255) NOT NULL default '',
`Uri` varchar(255) NOT NULL default '',
`Tags` text NOT NULL,
`Description` text NOT NULL,
`Time` int(11) NOT NULL default '0',
`Date` int(20) NOT NULL default '0',
`Owner` varchar(64) NOT NULL default '',
`Views` int(12) default '0',
`Status` enum('approved','disapproved','pending','processing','failed') NOT NULL default 'pending',
PRIMARY KEY  (`ID`),
KEY (`Owner`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

I hope it's will help you

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 28 Jun 2010

Thanks SashaE. I excuted the query on all the Ray tables from my remote computer replacing caps and lows table names (RayVideo_commentsFiles etc etc) and I got a Duplicate Entry error when I test upload. I suspected it is somehow affecting other tables causing the duplicate entry message.

I resolved the issue by reinstalling the sounds and video module. i.e., it needs to uninstall again the groups and events module.

Quote · 28 Jun 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.