Problem Description :: Forum Post Assistant (v1.2.1) : 27th April 2012 wrote:
Migration 1.0 to 1.5 Problem with SQL DB
Log/Error Message :: Forum Post Assistant (v1.2.1) : 27th April 2012 wrote:
jtablesession::store failed DB function failed with error number 1146 Table \'tsandal_jo153.jos_session\' doesn\'t exist SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( \'483b701c4684c1db62e96c2564c269f5\',\'1335357765\',\'\',\'0\',\'1\',\'1\' ) Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 76 bytes) in domain.xxx/libraries/joomla/error/exception.php on line 117
Log/Error Message :: Forum Post Assistant (v1.2.1) : 27th April 2012 wrote:
Also problema with the given Migrator and Migrator Assistent Modules. After using ist, the SQL DB of the new site seems to be empty (no tables at all) and only 3 error tables regarding to the following: DROP TABLE IF EXISTS `#__jf_content`; CREATE TABLE IF NOT EXISTS `#__jf_content` ( `id` int(10) unsigned NOT NULL auto_increment, `language_id` int(11) NOT NULL default \'0\', `reference_id` int(11) NOT NULL default \'0\', `reference_table` varchar(100) NOT NULL default \'\', `reference_field` varchar(100) NOT NULL default \'\', `value` text NOT NULL, `original_value` varchar(255) default NULL, `original_text` text, `modified` datetime NOT NULL default \'0000-00-00 00:00:00\', `modified_by` int(11) unsigned NOT NULL default \'0\', `published` tinyint(1) unsigned NOT NULL default \'0\', PRIMARY KEY (`id`) ) AUTO_INCREMENT=1 ; ALTER TABLE `#__jf_content` ADD INDEX `jfContent` ( `language_id` , `reference_id` , `reference_table` ) ; ALTER TABLE `#__jf_content` ADD INDEX `jfContentPublished` (`reference_id`, `reference_field`, `reference_table`, `language_id`, `published`); DROP TABLE IF EXISTS `#__languages`; CREATE TABLE `#__languages` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default \'\', `active` tinyint(1) NOT NULL default \'0\', `iso` varchar(20) default NULL, `code` varchar(20) NOT NULL default \'\', `shortcode` varchar(20) default NULL, `image` varchar(100) default NULL, `fallback_code` varchar(20) NOT NULL default \'\', `params` text, `ordering` int(11) NOT NULL default \'0\', PRIMARY KEY (`id`) ) AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `#__jf_tableinfo`; CREATE TABLE IF NOT EXISTS `#__jf_tableinfo` ( `id` int(11) NOT NULL auto_increment, `joomlatablename` varchar(100) NOT NULL default \'\', `tablepkID` varchar(100) NOT NULL default \'\', PRIMARY KEY (`id`) ) AUTO_INCREMENT=1 ;
Actions Taken To Resolve by Forum Post Assistant (v1.2.1) 27th April 2012 wrote:
I read nearly all posts, forum and youtube tutorials about to fix. Latestest it sais to alter the jos_session that could be a problem, but looking into the SQL DB, theres is no jos_xxxx (prefix) tables, theres is noting. An other installation there are only bak_xxxxx files. I really understand. I used and followed exactly all instruction available on the web, nothing works
Forum Post Assistant (v1.2.1) : 27th April 2012 wrote:
Basic Environment :: wrote:
Joomla! Instance :: Joomla! 1.5.23-Stable (senu takaa ama baji) 04-March-2011
Joomla! Configured :: Yes | Writable (644) | Owner: tsandal (uid: 32201/gid: 32204) | Group: tsandal (gid: 32204) | Valid For: 1.5
Configuration Options :: Offline: 0 | SEF: 0 | SEF Suffix: 0 | SEF ReWrite: 0 | .htaccess/web.config: No | GZip: 0 | Cache: 0 | FTP Layer: 0 | SSL: 0 | Error Reporting: -1 | Site Debug: 0 | Language Debug: 0 | Database Credentials Present: Yes
Host Configuration :: OS: Linux | OS Version: 3.2.15 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate | Doc Root: /home/tsandal/public_html/selfbondage.es | System TMP Writable: Yes
PHP Configuration :: Version: 5.2.17 | PHP API: cgi-fcgi | Session Path Writable: Unknown | Display Errors: 1 | Error Reporting: 6135 | Log Errors To: error_log | Last Known Error: | Register Globals: | Magic Quotes: 1 | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 64M | Max. POST Size: 64M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 256M
MySQL Configuration :: Version: 5.5.19-55 (Client:5.5.19) | Host: --protected-- (--protected--) | Collation: utf8_unicode_ci (Character Set: utf8) | Database Size: 116.42 KiB | #of _FPA_TABLE: 36
Detailed Environment :: wrote:
PHP Extensions :: date (5.2.17) | libxml () | openssl () | pcre () | zlib (1.1) | bcmath () | bz2 () | calendar () | ctype () | curl () | dbase () | dom (20031129) | hash (1.0) | filter (0.11.0) | ftp () | gd () | gettext () | session () | iconv () | standard (5.2.17) | json (1.2.1) | mbstring () | mcrypt () | mhash () | mime_magic (0.1) | mssql () | mysql (1.0) | SimpleXML (0.1) | odbc (1.0) | posix () | pspell () | Reflection (0.1) | imap () | SPL (0.2) | mysqli (0.1) | soap () | sockets () | exif (1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $) | tidy (2.0) | tokenizer (0.1) | wddx () | xml () | xmlreader (0.1) | xmlrpc (0.51) | xmlwriter (0.1) | xsl (0.1) | zip (1.8.11) | cgi-fcgi () | magickwand (1.0.
| imagick (3.0.1) | PDO (1.0.4dev) | pdo_sqlite (1.0.1) | SQLite (2.0-dev) | pdo_mysql (1.0.2) | SourceGuardian (8.2) | ionCube Loader () | Zend Optimizer () | Zend Engine (2.2.0) |
Potential Missing Extensions :: suhosin |
Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No Folder Permissions :: wrote:
Core Folders :: images/ (777) | components/ (777) | modules/ (777) | plugins/ (777) | language/ (777) | templates/ (777) | cache/ (777) | logs/ (777) | tmp/ (777) | administrator/components/ (777) | administrator/modules/ (777) | administrator/language/ (777) | administrator/templates/ (777) |
Elevated Permissions (First 10) :: None administrator/language/ (777) | components/ (777) | images/ (777) | images/banners/ (777) | images/stories/ (777) | language/ (777) | language/en-GB/ (777) | language/pdf_fonts/ (777) | logs/ (777) |
Extensions Discovered :: wrote:
Components :: SITE :: MailTo (1.5.0) | Wrapper (1.5.0) | User (1.5.0) |
Components :: ADMIN :: User Manager (1.5.0) | Module Manager (1.5.0) | Installation Manager (1.5.0) | Search (1.5.0) | Menus Manager (1.5.0) | Messaging (1.5.0) | Contact Items (1.0.0) | Polls (1.5.0) | Content Page (1.5.0) | Banners (1.5.0) | Cache Manager (1.5.0) | Mass Mail (1.5.0) | Control Panel (1.5.0) | Trash (1.0.0) | Media Manager (1.5.0) | Template Manager (1.5.0) | Configuration Manager (1.5.0) | Frontpage (1.5.0) | Weblinks (1.5.0) | Newsfeeds (1.5.0) | Language Manager (1.5.0) | Plugin Manager (1.5.0) |
Modules :: SITE :: Archived Content (1.5.0) | Menu (1.5.0) | Feed Display (1.5.0) | Login (1.5.0) | Footer (1.5.0) | Latest News (1.5.0) | Search (1.0.0) | Random Image (1.5.0) | Syndicate (1.5.0) | Sections (1.5.0) | Related Items (1.0.0) | Custom HTML (1.5.0) | Banner (1.5.0) | Wrapper (1.0.0) | Breadcrumbs (1.5.0) | Newsflash (1.5.0) | Statistics (1.5.0) | Who\'s Online (1.0.0) | Poll (1.5.0) | Most Read Content (1.5.0) |
Modules :: ADMIN :: Admin Submenu (1.0.0) | Quick Icons (1.0.0) | Feed Display (1.5.0) | Login Form (1.0.0) | Footer (1.0.0) | Unread Items (1.0.0) | Online Users (1.0.0) | Logged in Users (1.0.0) | Popular Items (1.0.0) | Toolbar (1.0.0) | User Status (1.5.0) | Custom HTML (1.5.0) | Admin Menu (1.0.0) | Title (1.0.0) | Items Stats (1.0.0) | Latest News (1.0.0) |
Plugins :: SITE :: Content - Email Cloaking (1.5) | Content - Pagebreak (1.5) | Content - Load Modules (1.5) | Content - Example (1.0) | Content - Vote (1.5) | Content - Page Navigation (1.5) | Content - Code Highlighter (Ge (1.5) | User - Joomla! (1.5) | User - Example (1.0) | Editor - TinyMCE 3 (3.2.6) | Editor - XStandard Lite for Jo (1.0) | Search - Weblinks (1.5) | Search - Content (1.5) | Search - Sections (1.5) | Search - Categories (1.5) | Search - Contacts (1.5) | Search - Newsfeeds (1.5) | System - SEF (1.5) | System - Debug (1.5) | System - Remember Me (1.5) | System - Log (1.5) | System - Cache (1.5) | System - Legacy (1.5) | System - Backlinks (1.5) | System - Mootools Upgrade (1.5) | XML-RPC - Joomla API (1.0) | XML-RPC - Blogger API (1.0) | Button - Pagebreak (1.5) | Button - Image (1.0.0) | Button - Readmore (1.5) | Authentication - Joomla (1.5) | Authentication - OpenID (1.5) | Authentication - Example (1.5) | Authentication - GMail (1.5) | Authentication - LDAP (1.5) |
Templates Discovered :: wrote:
Templates :: SITE :: JA_Purity (1.2.0) | rhuk_milkyway (1.0.2) | beez (1.0.0) |
Templates :: ADMIN :: Khepri (1.0) |
