MySql error [XOOPS general usage questions] - XOOPS Web Application System

1

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

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.

The art of asking questions.

3

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

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.

The art of asking questions.

5

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

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

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.

The art of asking questions.

8

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

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

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

Stats
Goal:	$100.00
Due Date:	May 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

MySql error

Re: MySql error

Re: MySql error

Re: MySql error

Re: MySql error

Re: MySql error

Re: MySql error

Xoops 2.0.16 content invalid???

Re: MySql error

Upgrading to 2.4.4

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}