Please Help: CollectionVersionBlockStyles error

Permalink
I put in another post that I cannot get my site which I have just transferred over to a live environment going.

But now I get this error:

An unexpected error occurred.

mysqlt error: [1146: Table 'c27ictm_rol.CollectionVersionBlockStyles' doesn't exist] in EXECUTE("select bID, arHandle, csrID from CollectionVersionBlockStyles where cID = '1' and cvID = '21' and csrID > 0")

See the Image attached.

The table 'CollectionVersionBlocksStyles' does exist but obviously has some data missing? This is the same as my offline copy of the database backup.

This is what is written there:
-- --------------------------------------------------------

--
-- Table structure for table `CollectionVersionBlocksStyles`
--

CREATE TABLE IF NOT EXISTS `CollectionVersionBlocksStyles` (
`cID` int(10) unsigned NOT NULL DEFAULT '0',
`cvID` int(10) unsigned NOT NULL DEFAULT '0',
`bID` int(10) unsigned NOT NULL DEFAULT '0',
`arHandle` varchar(255) NOT NULL,
`csrID` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`cID`,`cvID`,`bID`,`arHandle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

My Site.php file is this:

<?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'xxxxxxxn'); xx'ed out real info
define('DB_PASSWORD', 'xxxxxxxx!');
define('DB_DATABASE', 'xxxxxxxxl');
define('BASE_URL', 'http://www.domainname.org');
define('DIR_REL', '');

Fanflame
 
WebcentricLtd replied on at Permalink Reply
did you manually change the table name? In your create table query the table name is different by the looks of it - blocksstyles insted of blockstyles (?).
Fanflame replied on at Permalink Reply
Fanflame
AndyJ

Thank you for being so observant and for your reply which is VERY MUCH APPRECIATED!

I did have to manually change the case sensitivity which took me 4 1/2 hours so I must have missed this. I will try removing the 's' from Blocks. YEAH it worked!

However I notice from my sql table structure that I have

CollectionVersionBlocks; (with an 's')
CollectionVersionBlocksOutputCache (with an 's')
BUT - CollectionVersionBlockStyles (withOUT an 's')

How strange is that naming convention?

Now that the website is up and live I see that I have no Images just empty placement blocks? When I right click the empty block and copy the URL it leads me to concrete5/files/cache/whatever.jpg

However, in the instructions on the C5 website for moving a file we were instructed to clear the contents of the cache folder which I did! Was that wrong information?

I will manually add them all back in on line as this will be the quickest way I think with the time difference between the USA and the UK where I live and work.

Again thanks you for your help and continued hopeful advice.

Fanflame
ronyDdeveloper replied on at Permalink Reply
ronyDdeveloper
You are not suppose to do the case change manually. Here is an add-on available which will do the same for you.
http://www.concrete5.org/marketplace/addons/database-case-sensitivi...

Rony
Fanflame replied on at Permalink Reply
Fanflame
Hi Rony,

My issue was that when I copied the site I was trying to fathom the new Bitnami stack layout, and the file structure of C5 as this was my first site (of many) I created offline in windows not understanding the difference between that and linux caseSentitivity. THen when I had backed it all up and started uploading it I couldn't get enough information from the forum quick enough.

Someone else gave me that link and when I scanned it I thought that I would have to literally start again and that would take longer than maunally changing the CamelCase which I did and hated every minute of it! However I learned a lot about the structure and the making protocol of C5 which is a positive.

I will use that add on for my further sites!

However Now that the site is live I find that even though I can sign in - there is no EDIT button or Dashboard button at the top?

Can you advise please?

Fanflame
ronyDdeveloper replied on at Permalink Best Answer Reply
ronyDdeveloper
Edit button missing indicates that you have included jquery library in your them (which you supposed not to include as it is already included by core) or you have any error in your js. Check your browser console.

Rony
Fanflame replied on at Permalink Reply
Fanflame
Hello Rony,

Thanks for this and thanks for helping me out I REALLY APPRECIATE this as I am sitting on your answers...

I do not understand what you have said as I simply copied what I had on local server to online? I know nothing about js?

What can I do to resolve? Please...

Fanflame
Fanflame replied on at Permalink Reply
Fanflame
WHen you write:
"Edit button missing indicates that you have included jquery library in your them " did you mean THEME?

If so I had copied the Greek Yogurt theme and changed the css as I was advised to do. I renamed it to ictmt_greek_yogurt and put it in the Themes folder as instructed by someone. I hadn't included/added 'js' as I do not know what it is and do not know how to?

Fanflame
ronyDdeveloper replied on at Permalink Reply
ronyDdeveloper
Yes I mean the THEME, sorry for the typo. :)

You can PM me the login details as well as FTP details. I can have a look at it.
Fanflame replied on at Permalink Reply
Fanflame
Thanks Rony,

I will Gmail you as I cannot see a PM anywhere. I will also add you in on LinkedIn in a couple of minutes.

fanflame
Fanflame replied on at Permalink Reply
Fanflame
I thought that I must write to BIG UP Rony here. He has been superb with his help and advice and shows what the C5 forum is about. People helping each others within the community.

I obviously made several novice mistakes in the way I created the site offline as a first time user of C5 and Rony was able to isolate these and fix them.

He is a STAR !
WebcentricLtd replied on at Permalink Reply
glad you're making progress and Rony is helping you out. If you can't see the images it might just be that you need to recursively chmod your /files directory to 777 (you can likely do this through your ftp client.
Fanflame replied on at Permalink Reply
Fanflame
Thanks AndyJ,

I found that by running the Automated Jobs all the pages were indexed and that the images magically appeared!

Fanflame