1
ALineberger
Re: Transferring tables from one schema to another
  • 2005/8/2 18:22

  • ALineberger

  • Just popping in

  • Posts: 7

  • Since: 2005/6/27


Well, it appears to have worked. No errors yet.

Abel



2
ALineberger
Transferring tables from one schema to another
  • 2005/8/2 18:14

  • ALineberger

  • Just popping in

  • Posts: 7

  • Since: 2005/6/27


May be more of a mySQL question than XOOPs.

I am currently migrating from a 2.0.11 site to 2.2 site. Instead of following the update path, I decided to create a new site and am now trying to move the smartFAQ data from one site to the other. Besides having to rename the tables from xoops_smartfaq_faq/answers/categories to xxxxx_smartfaq_faq/answers/categories is there anything else of which I need to be aware?

I am using the mySQL Administrator for W2k3 so I thought I would just backup the old schema, and import those tables into the new schema, renaming the Table Names to match. SmartFAQ is already installed and running in the new installation.

Running v4.1.12 of MySQL / PHP v5

The overall goal is to eventually down the old site and switch the new site into it's place.

Abel



3
ALineberger
Re: Xoops On Crack?

Not to resurrect this beast once the stake was truly driven through it's heart, but having read the entire thread in one sitting, I am still wondering if the security holes seen by the Asian/Brazilian contingents were all fixed? Should you still use Protector - does it even apply after 2.0.12a?

Looking at GIJOE's change log for the latest version -
2.40RC2 (2005/4/4)
That's almost three months with no change. In fact no change since before 2.0.10 was released. That can be read as his supreme confidence that he's got it locked down. Or read as he's got better things to be working on as Protector is no longer as necessary as it was. I would truly like to know which of those two possibilities is closest to the truth.


Any learned commentary would be most appreciated.


---------------
Am I being paranoid? You betcha. Does it mean there ain't anybody after me? No bet.



4
ALineberger
Re: Smarty::fetch error on initial start
  • 2005/6/27 23:22

  • ALineberger

  • Just popping in

  • Posts: 7

  • Since: 2005/6/27


You are correct. The first setup page post installation requires the user to delete the /install directory and set mainfile.php to read-only. I had not seen this when I last posted.



5
ALineberger
Re: Smarty::fetch error on initial start
  • 2005/6/27 22:06

  • ALineberger

  • Just popping in

  • Posts: 7

  • Since: 2005/6/27


Right.

Apparently the Internet Guest Account doesn't need just write privileges on /Cache ,/templates_c, and /upload, and /mainfile.php - it needs Full permissions.

I am a little worried about the security ramifications here. Doesn't this mean that someone could upload a php script attack to your cache directory and execute it?



6
ALineberger
Re: Yet another blank page error - but with Error Report!!!
  • 2005/6/27 21:04

  • ALineberger

  • Just popping in

  • Posts: 7

  • Since: 2005/6/27


/templates_c/ tests as writable.

It looked to me from the error codes that Smarty was trying to fetch a series of non-existant files. Is this not the case?



7
ALineberger
Smarty::fetch error on initial start
  • 2005/6/27 20:21

  • ALineberger

  • Just popping in

  • Posts: 7

  • Since: 2005/6/27


Went through the standard "Blank Page T/S" and did manage to get an error report out. It seems that there are files missing from \templates_c\ - or atleast that's what I am deciphering. Downloaded both latest full versions, gz and zip and both were empty. Hrm. Here's the text of the error.
Quote:
Warning [PHP]: Smarty::fetch(D:/aan/xoops/templates_c\%%6E^6E8^6E8C036B%%db%3Asystem_block_login.html.php) [function.fetch]: failed to open stream: No such file or directory in file D:\aan\xoops\class\smarty\Smarty.class.php line 1255
Warning [PHP]: Smarty::fetch() [function.include]: Failed opening 'D:/aan/xoops/templates_c\%%6E^6E8^6E8C036B%%db%3Asystem_block_login.html.php' for inclusion (include_path='\php\ext;c:\php') in file D:\aan\xoops\class\smarty\Smarty.class.php line 1255
Warning [PHP]: Smarty::fetch(D:/aan/xoops/templates_c\%%42^428^428512AB%%db%3Asystem_block_mainmenu.html.php) [function.fetch]: failed to open stream: No such file or directory in file D:\aan\xoops\class\smarty\Smarty.class.php line 1255
Warning [PHP]: Smarty::fetch() [function.include]: Failed opening 'D:/aan/xoops/templates_c\%%42^428^428512AB%%db%3Asystem_block_mainmenu.html.php' for inclusion (include_path='\php\ext;c:\php') in file D:\aan\xoops\class\smarty\Smarty.class.php line 1255
Warning [PHP]: Smarty::fetch(D:/aan/xoops/templates_c\%%20^200^200DC337%%theme.html.php) [function.fetch]: failed to open stream: No such file or directory in file D:\aan\xoops\class\smarty\Smarty.class.php line 1248
Warning [PHP]: Smarty::fetch() [function.include]: Failed opening 'D:/aan/xoops/templates_c\%%20^200^200DC337%%theme.html.php' for inclusion (include_path='\php\ext;c:\php') in file D:\aan\xoops\class\smarty\Smarty.class.php line 1248


The files requested from the \class\smarty\ directory all exist. But there are no files in the \templates_c\ directory save and index.htm and an empty CVS directory.

Where'd I screw up?

System : W2k3SP1 / IIS 6.0
DB: mySQL 4.1.12
PHP: php5

As is IIS6 have set the Internet Guest Account to have write / modify on /cache, /uploads, templates_c/ and mainfile.php.
Thanks!




TopTop



Login

Who's Online

167 user(s) are online (105 user(s) are browsing Support Forums)


Members: 0


Guests: 167


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits