I apologize in advance for the length of this post.
I had a working sandbox of Joomla 1.6, with a database migrated from 1.5, and installed BS 7.0 beta. 7.0 recognized the files from the migrated database and seemed to be working well (I did not test thoroughly, but saw no errors and all displayed properly).
Because I had used an older database backup, the 1.6 site did not include more recent sermon files. So I used the Export/Import component to pull in files. Import completed without error, according to the component messages, but when I went to view studies, I saw only this:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/01/7578201/html/GraceChurch2/libraries/joomla/database/database/mysql.php on line 317
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/01/7578201/html/GraceChurch2/libraries/joomla/database/database/mysql.php on line 317
Warning: Invalid argument supplied for foreach() in /home/content/01/7578201/html/GraceChurch2/libraries/joomla/database/database/mysql.php on line 701
Warning: Invalid argument supplied for foreach() in /home/content/01/7578201/html/GraceChurch2/libraries/joomla/database/database/mysql.php on line 701
Warning: Invalid argument supplied for foreach() in /home/content/01/7578201/html/GraceChurch2/libraries/joomla/database/table.php on line 362
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/01/7578201/html/GraceChurch2/libraries/joomla/database/database/mysql.php on line 317
Warning: Invalid argument supplied for foreach() in /home/content/01/7578201/html/GraceChurch2/administrator/components/com_biblestudy/helpers/translated.php on line 16
Looking for solutions, I came across a different set of instructions which said to import BEFORE installing 7.0. I uninstalled everything, dropped tables from the database (both j16_bsms_XXX and jos_bsms_XXX, which I assumed were from old and newer databases), and started again with importing first, then installing 7.0.
Again, import and installation completed without error, per messages, but opening the component showed that my Admin template could not be displayed, and I had a whole string of error messages (pasted below). Clearing everything and trying again from scratch did not help.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/01/7578201/html/GraceChurch2/libraries/joomla/database/database/mysql.php on line 317
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/01/7578201/html/GraceChurch2/libraries/joomla/database/database/mysql.php on line 317
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/01/7578201/html/GraceChurch2/libraries/joomla/database/database/mysql.php on line 317
Warning: Invalid argument supplied for foreach() in /home/content/01/7578201/html/GraceChurch2/administrator/components/com_biblestudy/helpers/translated.php on line 16
Suggestions?
