PW 2.3.0: Unknown column 'field_images.modified' in 'field list'

[redrunner]

Hi,

I´ve downloaded and installed the current stable release 2.3.0 in order to take a first look at processwire.

Not having customized anything I´m getting the following error message:

Error: Exception: Unknown column 'field_images.modified' in 'field list' (in /www/htdocs/mysite/wire/core/Database.php line 118)

#0 /www/htdocs/mysite/wire/core/DatabaseQuery.php(84): Database->query(Object(DatabaseQuerySelect))
#1 /www/htdocs/mysite/wire/core/Fieldtype.php(421): DatabaseQuery->execute()
#2 [internal function]: Fieldtype->___loadPageField(Object(Page), Object(Field))
#3 /www/htdocs/mysite/wire/core/Wire.php(271): call_user_func_array(Array, Array)
#4 /www/htdocs/mysite/wire/core/Wire.php(229): Wire->runHooks('loadPageField', Array)
#5 /www/htdocs/mysite/wire/core/Page.php(651): Wire->__call('loadPageField', Array)
#6 /www/htdocs/mysite/wire/core/Page.php(651): FieldtypeImage->loadPageField(Object(Page), Object(Field))
#7 /www/htdocs/mysite/wire/core/Page.php(558): Page->getFieldValue('images')
#8 /www/htdocs/mysite/wire/core/Page.php(685): Page->get('images')
#9 /www/htdocs/mysite/site/templates/head.inc(82): Page->__get('images')
#10 /www/htdocs/mysite/site/templates/home.php

When I remove the following block from the head.inc file, the error disapears:

			if(count($homepage->images)) {
				$image = $homepage->images->getRandom();
				$thumb = $image->size(232, 176);
				echo "<a href='{$image->url}'><img id='photo' src='{$thumb->url}' alt='{$thumb->description}' width='{$thumb->width}' height='{$thumb->height}' /></a>";
			}

I´ve looked for the error message using google and the search function of this forum, but havn´t found anything.

What is the problem? Can someone help me?

[ryan]

It looks to me like PW must not have "ALTER TABLE" permissions to the database.  That's the only thing I can think of that would cause that error. Can you double check and let me know? Though I'd also be curious to know what PHP and MySQL version you are using, and if there were any other hiccups during the install process?

[redrunner]

Hi ryan,

It looks to me like PW must not have "ALTER TABLE" permissions to the database.  That's the only thing I can think of that would cause that error. Can you double check and let me know? Though I'd also be curious to know what PHP and MySQL version you are using, and if there were any other hiccups during the install process?

thanks a lot for your reply. The test hosting account had only a mysql version 4. After having checked the system requirements of PW i installed it on another webserver satisfying the requirements. Now processwire seems to work without any problems.

The reason for the posted error messages was the wrong mysql version.

Thanks a lot!