XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / MySql error
Register
1
chefry
MySql error

  • 2010/5/21 10:04

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


ok, I'm trying to get my old recipe site going again. I found a host that will give access to error logs so I can debug it. Unfortunately the database is so big that I can't import it. So I had to insert 181 tables using the query command for each one.

Now, at the end of the file are the commands:

Quote:

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;


But when I try to inser them using the Query command I get

Quote:

Error

SQL query:

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

MySQL said: Documentation
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'


Does anyone know a fix for this???


TIA!!!
2
ghia
Re: MySql error

  • 2010/5/21 10:22

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


I believe there are some complementary instructions at the beginning of the file that must be executed first. I think these instruction facilitate the restore of databases with different characteristics (collation, etc) then the one created.
They are in general not needed, else you need to include each partial restore with that starting and ending block.
3
chefry
Re: MySql error

  • 2010/5/21 10:46

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


So if i reinsert the starting block with the ending block in the same query it might work?
4
ghia
Re: MySql error

  • 2010/5/21 12:13

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Yes, in that case, it should not give the error.
But as said, in general, these instructions have no influence on the restore for XOOPS tables and may probably also simply left out.
5
chefry
Re: MySql error

  • 2010/5/21 14:48

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


ok, i'll try it

i'm also getting a fatal error

Quote:

Fatal error: Call to a member function stopTime() on a non-object in /home/franksre/public_html/header.php on line 35


any ideas?
6
chefry
Re: MySql error

  • 2010/5/21 15:17

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


these are all the the error's I'm getting... I reuploaded the class folder but it didn't see m to help

Quote:

Warning: include(/home/franksre/include/common.php) [function.include]: failed to open stream: No such file or directory in /home/franksre/public_html/mainfile.php on line 104

Warning: include() [function.include]: Failed opening '/home/franksre/include/common.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/franksre/public_html/mainfile.php on line 104

Warning: include_once(/home/franksre/class/xoopsblock.php) [function.include-once]: failed to open stream: No such file or directory in /home/franksre/public_html/header.php on line 29

Warning: include_once() [function.include]: Failed opening '/home/franksre/class/xoopsblock.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/franksre/public_html/header.php on line 29

Fatal error: Call to a member function stopTime() on a non-object in /home/franksre/public_html/header.php on line 35
7
ghia
Re: MySql error

  • 2010/5/21 16:42

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Seems a problem with the definitions for the physical paths in mainfile.php (missing public_html?).
Verify that they are correct.
Check also if the files from the error messages exists at their location. You can do also the file check (see release notes) to verify the core is completly uploaded to the server.
8
chefry
Xoops 2.0.16 content invalid???

  • 2010/5/22 0:58

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


ok, because of the errors I'm getting I ran xoops_md5.php

I deleted the missing files alerts, because they were all inthe install directory, but here's what I get

Quote:


banners.php content invalid
class/auth/auth.php content invalid
class/auth/auth_xoops.php content invalid
class/auth/authfactory.php content invalid
class/database/database.php content invalid
class/database/mysqldatabase.php content invalid
class/errorhandler.php content invalid
class/logger.php content invalid
class/module.textsanitizer.php content invalid
class/smarty/Config_File.class.php content invalid
class/smarty/Smarty.class.php content invalid
class/smarty/Smarty_Compiler.class.php content invalid
class/smarty/xoops_plugins/compiler.foreachq.php content invalid
class/smarty/xoops_plugins/compiler.includeq.php content invalid
class/smarty/xoops_plugins/compiler.xoAppUrl.php content invalid
class/smarty/xoops_plugins/compiler.xoImgUrl.php content invalid
class/smarty/xoops_plugins/function.xoops_link.php content invalid
class/smarty/xoops_plugins/resource.db.php content invalid
class/template.php content invalid
class/theme.php content invalid
class/theme_blocks.php content invalid
class/tree.php content invalid
class/uploader.php content invalid
class/xml/rss/xmlrss2parser.php content invalid
class/xoopsblock.php content invalid
class/xoopscomments.php content invalid
class/xoopsform/formcolorpicker.php content invalid
class/xoopsform/formtextdateselect.php content invalid
class/xoopsform/grouppermform.php content invalid
class/xoopsform/tableform.php content invalid
class/xoopsform/themeform.php content invalid
class/xoopsformloader.php content invalid
class/xoopslists.php content invalid
class/xoopstree.php content invalid
edituser.php content invalid
favicon.ico content invalid
footer.php content invalid
imagemanager.php content invalid
include/checklogin.php content invalid
include/comment_form.php content invalid
include/comment_new.php content invalid
include/comment_reply.php content invalid
include/cp_header.php content invalid
include/functions.php content invalid
include/notification_select.php content invalid
include/xoops13_header.php content invalid
kernel/avatar.php content invalid
kernel/block.php content invalid
kernel/comment.php content invalid
kernel/config.php content invalid
kernel/configcategory.php content invalid
kernel/configitem.php content invalid
kernel/configoption.php content invalid
kernel/group.php content invalid
kernel/groupperm.php content invalid
kernel/image.php content invalid
kernel/imagecategory.php content invalid
kernel/imageset.php content invalid
kernel/imagesetimg.php content invalid
kernel/member.php content invalid
kernel/module.php content invalid
kernel/notification.php content invalid
kernel/online.php content invalid
kernel/tplfile.php content invalid
kernel/tplset.php content invalid
kernel/user.php content invalid
language/english/comment.php content invalid
mainfile.dist.php content invalid
misc.php content invalid
modules/system/admin/banners/main.php content invalid
modules/system/admin/blocksadmin/blocksadmin.php content invalid
modules/system/admin/groupperm.php content invalid
modules/system/admin/groups/groupform.php content invalid
modules/system/admin/preferences/main.php content invalid
modules/system/admin/tplsets/main.php content invalid
modules/system/admin/tplsets/themeimgform.php content invalid
modules/system/admin/users/main.php content invalid
modules/system/admin.php content invalid
modules/system/blocks/system_blocks.php content invalid
modules/system/language/english/admin/blocksadmin.php content invalid
modules/system/templates/blocks/system_block_login.html content invalid
modules/system/templates/blocks/system_block_mainmenu.html content invalid
modules/system/templates/system_userform.html content invalid
modules/system/xoops_version.php content invalid
search.php content invalid
viewpmsg.php content invalid
End of files check.


Does anyone know why I'm getting these errors?

And worse yet, a friend of mine who is a php developer, set up my old site on their server as a test, and it worked fine :(
9
chefry
Re: MySql error

  • 2010/5/22 1:02

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


ok, i took /public_html out of mainfile.php and I'm still getting these errors

Quote:

Warning: include(/home/franksre/include/common.php) [function.include]: failed to open stream: No such file or directory in /home/franksre/public_html/mainfile.php on line 104

Warning: include() [function.include]: Failed opening '/home/franksre/include/common.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/franksre/public_html/mainfile.php on line 104

Warning: include_once(/home/franksre/class/xoopsblock.php) [function.include-once]: failed to open stream: No such file or directory in /home/franksre/public_html/header.php on line 29

Warning: include_once() [function.include]: Failed opening '/home/franksre/class/xoopsblock.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/franksre/public_html/header.php on line 29

Fatal error: Call to a member function stopTime() on a non-object in /home/franksre/public_html/header.php on line 35


I checked and made sure the files were there, and in fact, reuploaded them.

I also ran xoops_md5.php which gave a lot of content invalid errors (which I have posted in a separate thread)
10
chefry
Upgrading to 2.4.4

  • 2010/5/22 13:24

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


how can I upgrade from 2.0.16 to 2.4.4?

I'm thinking that it would be a lot easier to get my old site running if I did a clean install with all the updated modules and then inserted the mysql tables from the old database

what do you think?

I was using the modules:
WRAPS
BBEX
CITAS
CONTENT
DICTIONARY
WEBLINKS
RANDOM QUOTES
XBS META TAGS
ARCHCONTACT
Happy Linux Framework
Marquee
XOOPS Info
Code Data Management
wfchannel
iSearch
news
content
link-to-us
iFrames
Your Shortcuts
multiMenu
smartsection
Edito
userpage
RMSOFT Quick Pages
smartfaq
xfguestbook
SmartObject Framework
(1) 2 3 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

306 user(s) are online (284 user(s) are browsing Support Forums)

Members: 1

Guests: 305

Harald0123,

more...

Donat-O-Meter

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

Latest GitHub Commits