SubQuery Problem (1 reply)
- user warning: Table './programm_program/cache_content' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM cache_content WHERE cid = 'content:10312:10312' in /home/programm/public_html/includes/database.mysql.inc on line 174.
- user warning: Table './programm_program/cache_content' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM cache_content WHERE cid = 'content_type_info' in /home/programm/public_html/includes/database.mysql.inc on line 174.
- user warning: Table './programm_program/cache_content' is marked as crashed and should be repaired query: LOCK TABLES cache_content WRITE in /home/programm/public_html/includes/database.mysql.inc on line 174.
- user warning: Table './programm_program/cache_content' is marked as crashed and should be repaired query: UPDATE cache_content SET data = 'a:4:{s:11:\"field types\";a:3:{s:13:\"nodereference\";a:3:{s:5:\"label\";s:14:\"Node Reference\";s:6:\"module\";s:13:\"nodereference\";s:10:\"formatters\";a:4:{s:7:\"default\";a:3:{s:5:\"label\";s:12:\"Title (link)\";s:11:\"field types\";a:1:{i:0;s:13:\"nodereference\";}s:6:\"module\";s:13:\"nodereference\";}s:5:\"plain\";a:3:{s:5:\"label\";s:15:\"Title (no link)\";s:11:\"field types\";a:1:{i:0;s:13:\"nodereference\";}s:6:\"module\";s:13:\"nodereference\";}s:4:\"full\";a:3:{s:5:\"label\";s:9:\"Full node\";s:11:\"field types\";a:1:{i:0;s:13:\"nodereference\";}s:6:\"module\";s:13:\"nodereference\";}s:6:\"teaser\";a:3:{s:5:\"label\";s:6:\"Teaser\";s:11:\"field types\";a:1:{i:0;s:13:\"nodereference\";}s:6:\"module\";s:13:\"nodereference\";}}}s:5:\"image\";a:3:{s:5:\"label\";s:5:\"Image\";s:6:\"module\";s:10:\"imagefield\";s:10:\"formatters\";a:25:{s:21:\"100x100_thumb_default\";a:3:{s:5:\"label\";s:13:\"100x100_thumb\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:20:\"100x100_thumb_linked\";a:3:{s:5:\"label\";s:29:\"100x100_thumb as link to node\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:23:\"100x100_thumb_imagelink\";a:3:{s:5:\"label\";s:30:\"100x100_thumb as link to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:18:\"100x100_thumb_path\";a:3:{s:5:\"label\";s:32:\"path to 100x100_thumb derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:17:\"100x100_thumb_url\";a:3:{s:5:\"label\";s:31:\"url to 100x100_thumb derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:13:\"50x50_default\";a:3:{s:5:\"label\";s:5:\"50x50\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:12:\"50x50_linked\";a:3:{s:5:\"label\";s:21:\"50x50 as link to node\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:15:\"50x50_imagelink\";a:3:{s:5:\"label\";s:22:\"50x50 as link to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:10:\"50x50_path\";a:3:{s:5:\"label\";s:24:\"path to 50x50 derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:9:\"50x50_url\";a:3:{s:5:\"label\";s:23:\"url to 50x50 derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:17:\"MainImage_default\";a:3:{s:5:\"label\";s:9:\"MainImage\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:16:\"MainImage_linked\";a:3:{s:5:\"label\";s:25:\"MainImage as link to node\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:19:\"MainImage_imagelink\";a:3:{s:5:\"label\";s:26:\"MainImage as link to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:14:\"MainImage_path\";a:3:{s:5:\"label\";s:28:\"path to MainImage derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:13:\"MainImage_url\";a:3:{s:5:\"label\";s:27:\"url to MainImage derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:26:\"user_image_default_default\";a:3:{s:5:\"label\";s:18:\"user_image_default\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:25:\"user_image_default_linked\";a:3:{s:5:\"label\";s:34:\"user_image_default as link to node\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:28:\"user_image_default_imagelink\";a:3:{s:5:\"label\";s:35:\"user_image_default as link to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:23:\"user_image_default_path\";a:3:{s:5:\"label\";s:37:\"path to user_image_default derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:22:\"user_image_default_url\";a:3:{s:5:\"label\";s:36:\"url to user_image_default derivative\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagecache\";}s:7:\"default\";a:3:{s:5:\"label\";s:7:\"Default\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagefield\";}s:19:\"imagefield_nodelink\";a:3:{s:5:\"label\";s:12:\"link to node\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagefield\";}s:20:\"imagefield_imagelink\";a:3:{s:5:\"label\";s:13:\"link to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagefield\";}s:15:\"imagefield_path\";a:3:{s:5:\"label\";s:13:\"path to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagefield\";}s:14:\"imagefield_url\";a:3:{s:5:\"label\";s:12:\"url to image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagefield\";}}}s:4:\"link\";a:3:{s:5:\"label\";s:4:\"Link\";s:6:\"module\";s:4:\"link\";s:10:\"formatters\";a:6:{s:7:\"default\";a:3:{s:5:\"label\";s:24:\"Title, as link (default)\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";}s:3:\"url\";a:3:{s:5:\"label\";s:12:\"URL, as link\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";}s:5:\"plain\";a:3:{s:5:\"label\";s:15:\"URL, plain text\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";}s:5:\"short\";a:3:{s:5:\"label\";s:32:\"Short, as link with title \"Link\"\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";}s:5:\"label\";a:3:{s:5:\"label\";s:34:\"Label, as link with label as title\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";}s:8:\"separate\";a:3:{s:5:\"label\";s:22:\"Separate title and URL\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";}}}}s:12:\"widget types\";a:4:{s:20:\"nodereference_select\";a:4:{s:5:\"label\";s:11:\"Select List\";s:11:\"field types\";a:1:{i:0;s:13:\"nodereference\";}s:6:\"module\";s:13:\"nodereference\";i:0;s:13:\"nodereference\";}s:26:\"nodereference_autocomplete\";a:4:{s:5:\"label\";s:23:\"Autocomplete Text Field\";s:11:\"field types\";a:1:{i:0;s:13:\"nodereference\";}s:6:\"module\";s:13:\"nodereference\";i:0;s:13:\"nodereference\";}s:5:\"image\";a:4:{s:5:\"label\";s:5:\"Image\";s:11:\"field types\";a:1:{i:0;s:5:\"image\";}s:6:\"module\";s:10:\"imagefield\";i:0;s:5:\"image\";}s:4:\"link\";a:4:{s:5:\"label\";s:29:\"Text Fields for Title and URL\";s:11:\"field types\";a:1:{i:0;s:4:\"link\";}s:6:\"module\";s:4:\"link\";i:0;s:4:\"link\";}}s:6:\"fields\";a:3:{s:10:\"field_link\";a:13:{s:10:\"field_name\";s:10:\"field_link\";s:4:\"type\";s:4:\"link\";s:8:\"required\";s:1:\"0\";s:8:\"multiple\";s:1:\"0\";s:10:\"db_storage\";s:1:\"1\";s:10:\"attributes\";a:3:{s:6:\"target\";s:6:\"_blank\";s:3:\"rel\";s:0:\"\";s:5:\"class\";s:0:\"\";}s:7:\"display\";a:1:{s:10:\"url_cutoff\";s:2:\"80\";}s:3:\"url\";s:8:\"optional\";s:5:\"title\";s:4:\"none\";s:11:\"title_value\";s:0:\"\";s:13:\"enable_tokens\";N;s:6:\"widget\";a:1:{s:5:\"label\";s:4:\"Link\";}s:9:\"type_name\";s:12:\"addreference\";}s:19:\"field_nodereference\";a:10:{s:10:\"field_name\";s:19:\"field_nodereference\";s:4:\"type\";s:13:\"nodereference\";s:8:\"required\";s:1:\"0\";s:8:\"multiple\";s:1:\"0\";s:10:\"db_storage\";s:1:\"1\";s:19:\"referenceable_types\";a:15:{s:4:\"list\";s:4:\"list\";s:4:\"page\";s:4:\"page\";s:5:\"drigg\";s:5:\"drigg\";s:12:\"addreference\";i:0;s:4:\"blog\";i:0;s:4:\"book\";i:0;s:7:\"comment\";i:0;s:11:\"drupal_site\";i:0;s:4:\"feed\";i:0;s:18:\"feedapi_aggregator\";i:0;s:5:\"forum\";i:0;s:5:\"image\";i:0;s:9:\"geshinode\";i:0;s:5:\"story\";i:0;s:6:\"janode\";i:0;}s:13:\"advanced_view\";s:2:\"--\";s:18:\"advanced_view_args\";s:0:\"\";s:6:\"widget\";a:1:{s:5:\"label\";s:13:\"NodeReference\";}s:9:\"type_name\";s:12:\"addreference\";}s:11:\"field_image\";a:9:{s:10:\"field_name\";s:11:\"field_image\";s:4:\"type\";s:5:\"image\";s:8:\"required\";s:1:\"0\";s:8:\"multiple\";s:1:\"0\";s:10:\"db_storage\";s:1:\"1\";s:13:\"default_image\";a:5:{s:8:\"filename\";s:15:\"field_image.jpg\";s:8:\"filepath\";s:47:\"files/imagefield_default_images/field_image.jpg\";s:8:\"filemime\";s:10:\"image/jpeg\";s:8:\"filesize\";s:5:\"27487\";s:6:\"source\";s:20:\"default_image_upload\";}s:17:\"use_default_image\";i:1;s:6:\"widget\";a:1:{s:5:\"label\";s:5:\"Image\";}s:9:\"type_name\";s:12:\"addreference\";}}s:13:\"content types\";a:12:{s:12:\"addreference\";a:16:{s:4:\"type\";s:12:\"addreference\";s:4:\"name\";s:13:\"Add Reference\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:0:\"\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:8:\"ShortTip\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:23:\"Code Snippet (optional)\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:0:\"\";s:7:\"url_str\";s:12:\"addreference\";s:6:\"fields\";a:3:{s:10:\"field_link\";a:14:{s:10:\"field_name\";s:10:\"field_link\";s:4:\"type\";s:4:\"link\";s:8:\"required\";s:1:\"0\";s:8:\"multiple\";s:1:\"0\";s:10:\"db_storage\";s:1:\"1\";s:10:\"attributes\";a:3:{s:6:\"target\";s:6:\"_blank\";s:3:\"rel\";s:0:\"\";s:5:\"class\";s:0:\"\";}s:7:\"display\";a:1:{s:10:\"url_cutoff\";s:2:\"80\";}s:3:\"url\";s:8:\"optional\";s:5:\"title\";s:4:\"none\";s:11:\"title_value\";s:0:\"\";s:13:\"enable_tokens\";N;s:6:\"widget\";a:6:{s:13:\"default_value\";a:1:{i:0;a:3:{s:3:\"url\";s:0:\"\";s:5:\"title\";s:0:\"\";s:10:\"attributes\";s:2:\"N;\";}}s:17:\"default_value_php\";s:0:\"\";s:4:\"type\";s:4:\"link\";s:6:\"weight\";s:1:\"0\";s:5:\"label\";s:4:\"Link\";s:11:\"description\";s:0:\"\";}s:9:\"type_name\";s:12:\"addreference\";s:16:\"display_settings\";a:3:{s:5:\"label\";a:1:{s:6:\"format\";s:6:\"inline\";}s:6:\"teaser\";a:1:{s:6:\"format\";s:7:\"default\";}s:4:\"full\";a:1:{s:6:\"format\";s:7:\"default\";}}}s:11:\"field_image\";a:10:{s:10:\"field_name\";s:11:\"field_image\";s:4:\"type\";s:5:\"image\";s:8:\"required\";s:1:\"0\";s:8:\"multiple\";s:1:\"0\";s:10:\"db_storage\";s:1:\"1\";s:13:\"default_image\";a:5:{s:8:\"filename\";s:15:\"field_image.jpg\";s:8:\"filepath\";s:47:\"files/imagefield_default_images/field_image.jpg\";s:8:\"filemime\";s:10:\"image/jpeg\";s:8:\"filesize\";s:5:\"27487\";s:6:\"source\";s:20:\"default_image_upload\";}s:17:\"use_default_image\";i:1;s:6:\"widget\";a:11:{s:14:\"max_resolution\";s:1:\"0\";s:12:\"max_filesize\";s:1:\"0\";s:17:\"max_number_images\";s:1:\"0\";s:10:\"image_path\";s:0:\"\";s:15:\"file_extensions\";s:16:\"jpg jpeg png gif\";s:10:\"custom_alt\";i:0;s:12:\"custom_title\";i:0;s:4:\"type\";s:5:\"image\";s:6:\"weight\";s:1:\"3\";s:5:\"label\";s:5:\"Image\";s:11:\"description\";s:0:\"\";}s:9:\"type_name\";s:12:\"addreference\";s:16:\"display_settings\";a:3:{s:5:\"label\";a:1:{s:6:\"format\";s:6:\"hidden\";}s:6:\"teaser\";a:1:{s:6:\"format\";s:13:\"50x50_default\";}s:4:\"full\";a:1:{s:6:\"format\";s:13:\"50x50_default\";}}}s:19:\"field_nodereference\";a:11:{s:10:\"field_name\";s:19:\"field_nodereference\";s:4:\"type\";s:13:\"nodereference\";s:8:\"required\";s:1:\"0\";s:8:\"multiple\";s:1:\"0\";s:10:\"db_storage\";s:1:\"1\";s:19:\"referenceable_types\";a:15:{s:4:\"list\";s:4:\"list\";s:4:\"page\";s:4:\"page\";s:5:\"drigg\";s:5:\"drigg\";s:12:\"addreference\";i:0;s:4:\"blog\";i:0;s:4:\"book\";i:0;s:7:\"comment\";i:0;s:11:\"drupal_site\";i:0;s:4:\"feed\";i:0;s:18:\"feedapi_aggregator\";i:0;s:5:\"forum\";i:0;s:5:\"image\";i:0;s:9:\"geshinode\";i:0;s:5:\"story\";i:0;s:6:\"janode\";i:0;}s:13:\"advanced_view\";s:2:\"--\";s:18:\"advanced_view_args\";s:0:\"\";s:6:\"widget\";a:6:{s:13:\"default_value\";a:1:{i:0;a:0:{}}s:17:\"default_value_php\";s:0:\"\";s:4:\"type\";s:26:\"nodereference_autocomplete\";s:6:\"weight\";s:1:\"5\";s:5:\"label\";s:13:\"NodeReference\";s:11:\"description\";s:0:\"\";}s:9:\"type_name\";s:12:\"addreference\";s:16:\"display_settings\";a:3:{s:5:\"label\";a:1:{s:6:\"format\";s:6:\"hidden\";}s:6:\"teaser\";a:1:{s:6:\"format\";s:6:\"hidden\";}s:4:\"full\";a:1:{s:6:\"format\";s:6:\"hidden\";}}}}}s:4:\"blog\";a:16:{s:4:\"type\";s:4:\"blog\";s:4:\"name\";s:10:\"Blog entry\";s:6:\"module\";s:4:\"blog\";s:11:\"description\";s:169:\"A blog is a regularly updated journal or diary made up of individual posts shown in reversed chronological order. Each member of the site may create and maintain a blog.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"0\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"1\";s:9:\"orig_type\";s:4:\"blog\";s:7:\"url_str\";s:4:\"blog\";s:6:\"fields\";a:0:{}}s:4:\"book\";a:16:{s:4:\"type\";s:4:\"book\";s:4:\"name\";s:9:\"Book page\";s:6:\"module\";s:4:\"book\";s:11:\"description\";s:386:\"A book is a collaborative writing effort: users can collaborate writing the pages of the book, positioning the pages in the right order, and reviewing or modifying pages previously written. So when you have some information to share or when you read a page of the book and you didn\'t like it, or if you think a certain page could have been written better, you can do something about it.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"0\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"1\";s:9:\"orig_type\";s:4:\"book\";s:7:\"url_str\";s:4:\"book\";s:6:\"fields\";a:0:{}}s:7:\"comment\";a:16:{s:4:\"type\";s:7:\"comment\";s:4:\"name\";s:7:\"Comment\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:46:\"A comment for use with the nodecomment module.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:7:\"Subject\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:0:\"\";s:7:\"url_str\";s:7:\"comment\";s:6:\"fields\";a:0:{}}s:5:\"drigg\";a:16:{s:4:\"type\";s:5:\"drigg\";s:4:\"name\";s:8:\"Question\";s:6:\"module\";s:5:\"drigg\";s:11:\"description\";s:15:\"Digg-style node\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:11:\"Description\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"0\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"1\";s:9:\"orig_type\";s:5:\"drigg\";s:7:\"url_str\";s:5:\"drigg\";s:6:\"fields\";a:0:{}}s:4:\"feed\";a:16:{s:4:\"type\";s:4:\"feed\";s:4:\"name\";s:4:\"Feed\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:49:\"Items from these feeds will be turned into nodes.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:4:\"feed\";s:7:\"url_str\";s:4:\"feed\";s:6:\"fields\";a:0:{}}s:18:\"feedapi_aggregator\";a:16:{s:4:\"type\";s:18:\"feedapi_aggregator\";s:4:\"name\";s:24:\"Feed (lightweight items)\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:90:\"Aggregates RSS or Atom feeds. Feed items will be turned into lightweight database entries.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"0\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:0:\"\";s:7:\"url_str\";s:18:\"feedapi-aggregator\";s:6:\"fields\";a:0:{}}s:9:\"geshinode\";a:16:{s:4:\"type\";s:9:\"geshinode\";s:4:\"name\";s:16:\"Source code node\";s:6:\"module\";s:9:\"geshinode\";s:11:\"description\";s:43:\"Source code with GeSHi syntax highlighting.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"0\";s:8:\"modified\";s:1:\"0\";s:6:\"locked\";s:1:\"1\";s:9:\"orig_type\";s:9:\"geshinode\";s:7:\"url_str\";s:9:\"geshinode\";s:6:\"fields\";a:0:{}}s:5:\"image\";a:16:{s:4:\"type\";s:5:\"image\";s:4:\"name\";s:5:\"Image\";s:6:\"module\";s:5:\"image\";s:11:\"description\";s:83:\"An image (with thumbnail). This is ideal for publishing photographs or screenshots.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"0\";s:8:\"modified\";s:1:\"0\";s:6:\"locked\";s:1:\"1\";s:9:\"orig_type\";s:5:\"image\";s:7:\"url_str\";s:5:\"image\";s:6:\"fields\";a:0:{}}s:4:\"list\";a:16:{s:4:\"type\";s:4:\"list\";s:4:\"name\";s:4:\"List\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:0:\"\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:11:\"Topic Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:28:\"(Optional) Topic Description\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:0:\"\";s:7:\"url_str\";s:4:\"list\";s:6:\"fields\";a:0:{}}s:4:\"page\";a:16:{s:4:\"type\";s:4:\"page\";s:4:\"name\";s:4:\"Page\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:83:\"If you want to add a static page, like a contact page or an about page, use a page.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:4:\"page\";s:7:\"url_str\";s:4:\"page\";s:6:\"fields\";a:0:{}}s:5:\"story\";a:16:{s:4:\"type\";s:5:\"story\";s:4:\"name\";s:5:\"Story\";s:6:\"module\";s:4:\"node\";s:11:\"description\";s:219:\"Stories are articles in their simplest form: they have a title, a teaser and a body, but can be extended by other modules. The teaser is part of the body too. Stories may be used as a personal blog or for news articles.\";s:4:\"help\";s:0:\"\";s:9:\"has_title\";s:1:\"1\";s:11:\"title_label\";s:5:\"Title\";s:8:\"has_body\";s:1:\"1\";s:10:\"body_label\";s:4:\"Body\";s:14:\"min_word_count\";s:1:\"0\";s:6:\"custom\";s:1:\"1\";s:8:\"modified\";s:1:\"1\";s:6:\"locked\";s:1:\"0\";s:9:\"orig_type\";s:5:\"story\";s:7:\"url_str\";s:5:\"story\";s:6:\"fields\";a:0:{}}}}', created = 1337882677, expire = 0, headers = '' WHERE cid = 'content_type_info' in /home/programm/public_html/includes/database.mysql.inc on line 174.
- user warning: Table './programm_program/cache_content' is marked as crashed and should be repaired query: LOCK TABLES cache_content WRITE in /home/programm/public_html/includes/database.mysql.inc on line 174.
- user warning: Table './programm_program/cache_content' is marked as crashed and should be repaired query: UPDATE cache_content SET data = 'a:0:{}', created = 1337882677, expire = 0, headers = '' WHERE cid = 'content:10312:10312' in /home/programm/public_html/includes/database.mysql.inc on line 174.
Submitted by programmer on Thu, 08/14/2008 - 23:47.
I'm having trouble with the following query, if only one result is returned it executes in a second or two, however if there are multiple reuslts it errors out. I also tried to us = ANY and = ALL and the query runs endlessly. Any suggestions?
SELECT t1.DATE, t1.REASON, t1.TITLE, Left( t1.REASON, 8 ) AS CLAIM_NO, Right( t1.REASON, 2 ) AS STAGE, t1.ID AS transatn_ID, t1.CLAIM, o1.ID AS ORDER_ID, o1.SUBREF, t1.SPOOL_ORD
FROM order_ln o1
INNER JOIN transatn t1 ON o1.ID = t1.TRANS_REF
WHERE
t1.ID =
( SELECT max( t1.ID ) AS ID
FROM order_ln o1
INNER JOIN transatn t1 ON o1.ID = t1.TRANS_REF
WHERE t1.DATA_TYPE = 'CM'
AND t1.`DATABASE` = 'CLAIM '
AND t1.REASON LIKE '%'
AND t1.TRANS_REF =2000563600
GROUP BY left( REASON, 8 )
)