Jump to content

Peter Bickford

Clients
  • Posts

    9
  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Peter Bickford's Achievements

  1. Thanks so much! Had to download PHP Manager from here: https://www.iis.net/downloads/community/2018/05/php-manager-150-for-iis-10 But that worked beautifully, thanks! -Pete
  2. I understand, but does anyone know how to set the version it's looking for in a Windows/IIS environment? Best I found was to change the environment variables, but that was ineffective.
  3. Running InvisionCommunity Under Windows. PHP versions 7.4 and 8.0 are both installed on the server, and the environment variable for PHP 8.0 is set first in the Windows Environment Variables. Typing "Php -v" at the command line confirms that PHP 8.0 is found first, but our web site is insisting it's running under 7.4. How do I get it to see PHP 8.0? Thanks for any help, -Pete
  4. Our site has been throwing the following errors since running the latest Invision upgrade, and the Support tools section of the AdminCP is now no longer available. . 10/5/2022 09:55 uncaught_exception Error: Call to undefined function IPS\Image\gd_info() (0) #0 C:\websites\forums.comicbase.com\www\sy... 10/5/2022 09:54 template_error Error: Call to undefined function IPS\Image\gd_info() in C:\websites\forums.comicbase.com\www\system... What are my steps to troubleshoot/revert? Any help would be appreciated here... -Pete
  5. Ok, chalk this one up to my MySQL learning curve (I come from SQL Server/SQLite--the file storage structure of MySQL/InnoDB is really foreign to me). Your advice to clear databases before restoring was right on point--I just didn't understand that in MySQL world, that didn't mean firing up the database engine, disassocating the objects from the database store, then shutting the works all down again [as you'd do in SQL Server or the like]). Instead, it just meant delete all pre-existing .idb files from the data store folder before restoring the file backup! (Thumps head against desk) Since I wasn't clearing files (and I was simultaneously assuming that my backup program was restoring folders to their same state instead of leaving existing files while copying/replacing old ones in the directory), I was on a slippery slope toward database schema corruption hell. As soon as I deleted the appropriate data folders, then restored (telling Acronis [my backup program] to restore original privileges) all was well. Thanks for your help, guys--sometimes when you're this new to an environment, it takes a while to get your bearings! -Pete
  6. It was a disk image/file restore, so no database prep prior to putting the files back. It looks like other WP/MySQL schemas were OK, but the CBforums one got wonky in the restore (opening it with MySQL Workbench gives "Tables could not be fetched" / "Table 'cbforums.core_anonmous_posts' doesn't exist. ) Unfortunately, while I can see it in the tables list, trying to drop it fails ('doesn't exist'), as does Create Table --ironically because it doesn't exist! Error Code: 1146. Table 'cbforums.core_anonymous_posts' doesn't exist Is there any sort of MySQL "Validate schema and/or copy only real tables" action that can be taken to try to unscramble things? (unfortunately, DUMP is failing, claiming numerous tables don't exist). The only consolation is that the affected tables seem to apply only to the new achievements in 3.6 -- as long as I don't mind having a basically unstable DB structure and never upgrade, it all still runs (ugh!) -Pete
  7. (Reposting since the problem recurred when attempting to upgrade) Moving from v4.5.2 to 4.6.7, getting the following error when attempting to upgrade: SELECT count(*) FROM `core_anonymous_posts` IPS\Db\Exception: Table 'cbforums.core_anonymous_posts' doesn't exist (1146) #0 C:\websites\forums.comicbase.com\www\system\Db\Select.php(383): IPS\_Db->preparedQuery() Wonder if something got out of sync after having to do a recent restore from backup of the site -- I had recently upgraded to 4.6.2, but the restore I had to do reverted it to 4.5.2 -- might some data / tables have gotten out of sync? To attempt to reset things to a normal state, I have reverted the following directories on my machine: - C:\Program Files\MySQL - [ProgramData]\MySQL (which held the data directory) - The web page directory: C:\websites\forums.[myforum].com Is there either a manual fix to cause the upgrade to create the missing table, or is there another directory involved which I can restore in order to set the install to a normal state so it upgrades normally?
  8. Reverted to NOT SOLVED -- Restoring the MySQL, ProgramData\MySQL (which included the DB data), as well as the actual directory the forums were stored in seems to have at least restored the forums to working order, HOWEVER -- -- after several seconds longer than before when doing the update, I get "A cnfiguration error has occurred" EX1146 -- SELECT count(*) FROM `core_anonymous_posts` IPS\Db\Exception: Table 'cbforums.core_anonymous_posts' doesn't exist (1146) (Basically back to the original problem) Is there a manual fix/way to create or recreate this table? I did manage to revert my forums to 3.5.2, and the forums seem operable (no longer getting other random errors), but the upgrade still fails. -Pete
  9. Had to roll MySQL back from a backup recently, and the forums came up, but getting various DB errors--particularly when trying to upgrade to v4.6.7 In particular, the upgrade fails with a '[myforumname].core_anonymous_posts' doesn't exist Any idea how to recreate/fix this? -Pete Possibly relevant: my other forum, which had not been upgrade to 4.6 previously, does not have this issue. Is there a way to re-run the upgrade from 4.5 to 4.6 (which, presumably, created this table?) -Pete
×
×
  • Create New...