Support Forums - All Posts - XOOPS Web Application System

61

Re: mylinks - salvage rescue

2007/3/1 23:17
ukandrewf
Friend of XOOPS
Posts: 198
Since: 2002/12/2

I'm still struggling with this problem. I have a database backup of the tables i need for this module but can't seem to restore them correctly.

Quote:

#NAME?
-- version 2.6.0-beta3
--http://www.phpmyadmin.net
--
#NAME?
-- Generation Time: Jul 15 2006 at 06:02 PM
-- Server version: 4.0.27
-- PHP Version: 4.3.9
--
-- Database: `andrew_xoops`
--

-- --------------------------------------------------------

--
-- Table structure for table `xoops_mylinks_links`
--

CREATE TABLE `xoops_mylinks_links` (
`lid` int(11) unsigned NOT NULL auto_increment
`cid` int(5) unsigned NOT NULL default '0'
`title` varchar(100) NOT NULL default ''
`url` varchar(100) NOT NULL default ''
`email` varchar(60) NOT NULL default ''
`logourl` varchar(60) NOT NULL default ''
`submitter` int(11) unsigned NOT NULL default '0'
`status` tinyint(2) NOT NULL default '0'
`date` int(10) NOT NULL default '0'
`hits` int(11) unsigned NOT NULL default '0'
`rating` double(6 4) NOT NULL default '0.0000'
`votes` int(11) unsigned NOT NULL default '0'
`comments` int(11) unsigned NOT NULL default '0'
PRIMARY KEY (`lid`)
KEY `cid` (`cid`)
KEY `status` (`status`)
KEY `title` (`title`(40))
) TYPE=MyISAM AUTO_INCREMENT=4484 ;

--
-- Dumping data for table `xoops_mylinks_links`
--

INSERT INTO `xoops_mylinks_links` VALUES (343 7 'Treepad: Personal Information Manager Organizer Word Processor PIM Search Engine Database 'http://www.treepad.com' 'nospam@freebyte.com' '' 549 1 1 0 0 0 0);

this should restore ok right (there's much more data this is just a sample for this forum.

I'm running phpmyadmin and running this backup as an sql script.

any ideaS?

Andrew

--
Andrew
Power Tools Forum - ColourNation - Marvellous - London Hairdressers

62

Re: mylinks - salvage rescue

2007/2/7 21:53
ukandrewf
Friend of XOOPS
Posts: 198
Since: 2002/12/2

thanks for the tip (and i wish i was in florida now ;)

the sql in the mylinks module wasn't that helpful but I did find a backup file I made just for the mylinks module which looks like this.

Quote:

-- phpMyAdmin SQL Dump
-- version 2.6.0-beta3
--http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 15, 2006 at 06:02 PM
-- Server version: 4.0.27
-- PHP Version: 4.3.9
--
-- Database: `andrew_xoops`
--

-- --------------------------------------------------------

--
-- Table structure for table `xoops_mylinks_links`
--

CREATE TABLE `xoops_mylinks_links` (
`lid` int(11) unsigned NOT NULL auto_increment,
`cid` int(5) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`logourl` varchar(60) NOT NULL default '',
`submitter` int(11) unsigned NOT NULL default '0',
`status` tinyint(2) NOT NULL default '0',
`date` int(10) NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0',
`rating` double(6,4) NOT NULL default '0.0000',
`votes` int(11) unsigned NOT NULL default '0',
`comments` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`lid`),
KEY `cid` (`cid`),
KEY `status` (`status`),
KEY `title` (`title`(40))
) TYPE=MyISAM AUTO_INCREMENT=4484 ;

--
-- Dumping data for table `xoops_mylinks_links`

SQL access visa MYsql Databases.

Do I simply import this backup? Anywhere? Anything I should know before it try it?

--
Andrew
Power Tools Forum - ColourNation - Marvellous - London Hairdressers

63

mylinks - salvage rescue

2007/2/4 22:54
ukandrewf
Friend of XOOPS
Posts: 198
Since: 2002/12/2

I have a site which was built to list cool software. I used the mylinks module to create the software database with ranks, comments etc.

My host (SpiderSaid.com) just vanished into thin air one day last july and I lost my whole site. I did have some backups but the site never restored properly.

I've now take the step of a fresh 2.0.16 install and then reinstalled the modules into this fresh install - but using the previousl sql database which has all the data. Some of this worked the forums for example are all back now.

I don't know enought about sql but i know the 3000+ software database is there but can't quite get it working in the new in stall. I suspect I need to move/rename/edit some of the tables to make it work but don't know which.

I suspect the mylinks data is somewhere:-

Quote:

xoops_groups
xoops_groups_system_link
xoops_groups_users_link 3,705
xoops_group_permission 365

or here

xoops_myh_act Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 3.0 KiB -
xoops_myh_cache Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
xoops_myh_cat Browse Structure Search Insert Empty Drop 152 MyISAM latin1_swedish_ci 10.2 KiB -
xoops_myh_gtu Browse Structure Search Insert Empty Drop 3,274 MyISAM latin1_swedish_ci 114.4 KiB -
xoops_myh_gtu_reg Browse Structure Search Insert Empty Drop 3 MyISAM latin1_swedish_ci 2.1 KiB -
xoops_myh_gtu_sm Browse Structure Search Insert Empty Drop 6 MyISAM latin1_swedish_ci 7.0 KiB -
xoops_myh_pd Browse Structure Search Insert Empty Drop 42 MyISAM latin1_swedish_ci 24.4 KiB -
xoops_myh_src

and should be here

xoops_mylinks_broken Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
xoops_mylinks_cat Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
xoops_mylinks_links Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
xoops_mylinks_mod Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
xoops_mylinks_text Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KiB -
xoops_mylinks_votedata

can anyone help me fix this.

The other route is to examine the database backups and see if we can restore straight from them - maybe there's something simple wrong. When I try restoring from them I get a site but with no blocks - no login block and no users in db so can't access the site.

thanks in advance.

Andrew

--
Andrew
Power Tools Forum - ColourNation - Marvellous - London Hairdressers

64

Re: register.php form fill problem

2007/1/29 17:58
ukandrewf
Friend of XOOPS
Posts: 198
Since: 2002/12/2

doh!! thanks for that wonder how long it was like that for ;)

--
Andrew
Power Tools Forum - ColourNation - Marvellous - London Hairdressers

65

Re: register.php form fill problem

2007/1/29 16:08
ukandrewf
Friend of XOOPS
Posts: 198
Since: 2002/12/2

Quote:

$reg_form = new XoopsThemeForm(_US_USERREG, "userinfo", "register.php", "post", true);
$uname_size = $xoopsConfigUser['maxuname'] < 25 ? $xoopsConfigUser['maxuname'] : 25;
$reg_form->addElement(new XoopsFormText(_US_NICKNAME, "uname", $uname_size, $uname_size, $myts->htmlSpecialChars($uname)), true);
$reg_form->addElement($email_tray);
$reg_form->addElement(new XoopsFormText(_US_WEBSITE, "url", 25, 255, $myts->htmlSpecialChars($url)));

the solution appears to be in here /include/registerform.php

but i can't work out where. It appears that a text box is created with size 25 and max characters 25 too which all seems fine but then when it actually loads in a browser it's 0,0 ??

help

--
Andrew
Power Tools Forum - ColourNation - Marvellous - London Hairdressers

66

register.php form fill problem

2007/1/29 15:24
ukandrewf
Friend of XOOPS
Posts: 198
Since: 2002/12/2

as an annoymous user trying to register on my site..

http://www.colournation.com/register.php

I CAN'T fill in the username field (but can type in other fields) this means users can't register.

I've tried this under firefox and latest IE but neither browser work.

I think the reason is the the text box size and max characters are both set to '0' ... BUT where do i change that? I thought maybe in register.php but i can't find it in there.

thanks

Andrew

--
Andrew
Power Tools Forum - ColourNation - Marvellous - London Hairdressers

67

Re: Only variable references should be returned by reference

2006/8/24 23:17
ukandrewf
Friend of XOOPS
Posts: 198
Since: 2002/12/2

thanks :) he says here that:-

Quote:

these alarms do not deteriorate the functionalities of the heart system, therefore not of concern.

Therefore maybe I'm asking the wrong question.

I can see my site as linked baove but there is no login boxes so I can't access admin.php.

How can I access admin.php if i can't login?

Andrew

--
Andrew
Power Tools Forum - ColourNation - Marvellous - London Hairdressers

68

Only variable references should be returned by reference

2006/8/23 22:11
ukandrewf
Friend of XOOPS
Posts: 198
Since: 2002/12/2

I've just moved my site from one host to another. (I was with spidersaid for three years but my site is down and they aren't replying).

Everything has moved across but when i restored the sql db i got:-

Quote:

Error

SQL query:

INSERT INTO `xoops_myh_src`
VALUES ( 7, 0x687474703a2f2f702e6d6f72656f7665722e636f6d2f6367692d6c6f63616c2f706167653f633d496e7465726e6574253230666561747572657326616d703b6f3d727373, 0x496e7465726e6574206665617475726573, 0x, '', 14400, 14400, 0 ) ;

MySQL said: Documentation
#1054 - Unknown column '0x' in 'field list'

The site loads but with no blocks herehttp://89.145.66.200/~txxwrcpd/index.php

switching on debug i get 30 reports like this...

Quote:

Only variable references should be returned by reference

Any Ideas?

--
Andrew
Power Tools Forum - ColourNation - Marvellous - London Hairdressers

69

Re: cbb 3.04: Usage Questions

2006/7/30 23:45
ukandrewf
Friend of XOOPS
Posts: 198
Since: 2002/12/2

thanks for the clarification :)

Quote:

5) The big one: Is there a way to change the default view from 'Last 100 days' to 'From Beginning'?

Can anyone help me on this one? I think Google is not indexing me properly because it's not seeing posts over 100 days old clearly.

Any help approeciated.

--
Andrew
Power Tools Forum - ColourNation - Marvellous - London Hairdressers

70

Re: what is the best SQL editor - local language

2006/7/24 8:25
ukandrewf
Friend of XOOPS
Posts: 198
Since: 2002/12/2

ok yes i have phpmyadmin access

(although I have next to no knowledge of it or sql queries).

would i type exactly
Quote:

UPDATE xoopsprefix_linkstable set fieldname = 1 WHERE (optional where statement);

to achieve what i want?

Do I need to specificy like find '0' replace with '1'?

thanks

Andrew

--
Andrew
Power Tools Forum - ColourNation - Marvellous - London Hairdressers

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

Forum Index

Re: mylinks - salvage rescue

Re: mylinks - salvage rescue

mylinks - salvage rescue

Re: register.php form fill problem

Re: register.php form fill problem

register.php form fill problem

Re: Only variable references should be returned by reference

Only variable references should be returned by reference

Re: cbb 3.04: Usage Questions

Re: what is the best SQL editor - local language

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 }}