Support Forums - All Posts - XOOPS Web Application System

31

Re: error help..

2005/12/1 21:45
highlander
Not too shy to talk
Posts: 151
Since: 2004/12/5

Indeed Bender,

my session table looks very different aswell.


-- phpMyAdmin SQL Dump

-- version 2.6.4-pl2

-- http://www.phpmyadmin.net

-- 

-- Host: localhost

-- Generation Time: Dec 01, 2005 at 10:46 PM

-- Server version: 4.0.25

-- PHP Version: 4.3.11

-- 

-- Database: `xxxxxx`

-- 



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



-- 

-- Table structure for table `xoops_session`

-- 



CREATE TABLE `xoops_session` (

  `sess_id` varchar(32) NOT NULL default '',

  `sess_updated` int(10) unsigned NOT NULL default '0',

  `sess_ip` varchar(15) NOT NULL default '',

  `sess_data` text NOT NULL,

  PRIMARY KEY  (`sess_id`),

  KEY `updated` (`sess_updated`)

) TYPE=MyISAM;

I am guessing that your XOOPS version does not have a table like your SQL command either. This is the reason your getting this nasty message. As you can see from my export the session table has the following columns : sees_id, sess_updated, sess_ip and sess_data.

I tried your site but could not quite read enough to try and register

greetings Highlander

So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
www.AnimalPedigree.com

32

Re: DB Issue

2005/12/1 21:36
highlander
Not too shy to talk
Posts: 151
Since: 2004/12/5

Hi Xetox,

As long as your XOOPS version are the same (to keep things simple) it should not be too hard.

Use PhpMyAdmin (or an other database administration tool) to export the table(s) with users form the old DB and use the same tool to import the table(s) into the new DB.

for XOOPS 2.0.13.2 (my version) you will need to export the following table : "<prefix>_users" and for the permissions you'll need to do the same for "<prefix>_groups_users_link" and "<prefix>_groups".

Use the export function to make a full backup (all tables) first just incase you press the wrong buttons !!

Hope this helps, Highlander

So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
www.AnimalPedigree.com

33

Re: Anti-spam guestbook

2005/12/1 10:45
highlander
Not too shy to talk
Posts: 151
Since: 2004/12/5

A guestbook with anti-spam features can be found here.

It's XF Guestbook 2.30RC2.

I found it by doing a search for "spam guestbook" on this site .

Kind regards, Highlander

So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
www.AnimalPedigree.com

34

Re: Server Crash

2005/11/30 15:33
highlander
Not too shy to talk
Posts: 151
Since: 2004/12/5

Hi Xetox,

You need to check the settings in mainfile.php

good luck, Highlander

So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
www.AnimalPedigree.com

35

Re: Notification doesn't work at all

2005/11/29 13:43
highlander
Not too shy to talk
Posts: 151
Since: 2004/12/5

have you tried recreating the notification templates ?

kind regards, Highlander

So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
www.AnimalPedigree.com

36

Re: How can I change the Web Links sorted by popularity initially?

2005/11/28 18:23
highlander
Not too shy to talk
Posts: 151
Since: 2004/12/5

Hi Doug,

You need to change the template mylinks_index.html to do this.

in the template mylinks_index.html
find the following :


<a href="<{$xoops_url}>/modules/mylinks/viewcat.php?cid=<{$category.id}>"><img src="<{$category.image}>" height="50" border="0" alt="" /></a>

and change to :


<a href="<{$xoops_url}>/modules/mylinks/viewcat.php?cid=<{$category.id}>&orderby=hitsD"><img src="<{$category.image}>" height="50" border="0" alt="" /></a>

and find :


<td valign="top" width="40%"><a href="<{$xoops_url}>/modules/mylinks/viewcat.php?cid=<{$category.id}>"><b><{$category.title}></b></a>&nbsp;(<{$category.totallink}>)<br /><{$category.subcategories}></td>

and change that to :


<td valign="top" width="40%"><a href="<{$xoops_url}>/modules/mylinks/viewcat.php?cid=<{$category.id}>&orderby=hitsD"><b><{$category.title}></b></a>&nbsp;(<{$category.totallink}>)<br /><{$category.subcategories}></td>

good luck !

Highlander

So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
www.AnimalPedigree.com

37

mysql search for 'funny' characters

2005/11/27 11:58
highlander
Not too shy to talk
Posts: 151
Since: 2004/12/5

Hi All,

How would I let MySQL search for words starting with a 'strange' character ?


SELECT name FROM table WHERE name LIKE 'A%'

returns all the names that start with an A. (duh)


SELECT name FROM table WHERE name LIKE 'Å%'

returns all the names that start with an Å. (good)


SELECT name FROM table WHERE name LIKE 'À%'

returns all the names that start with an A. (strange)

Is there a way to get consistent results ? ie seaching for an À should give me an À and not an A ??

Hope someone can point me in the right direction.

greetings Highlander

So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
www.AnimalPedigree.com

38

Re: Upgraded from 2.0.7.3 to 2.2.3

2005/11/26 20:23
highlander
Not too shy to talk
Posts: 151
Since: 2004/12/5

Hi Zioncurtain,

I am not sre if a clean install of 2.2.3 is a better option or not; perhaps others are in a better posistion to advise you on that one (I am still running 2.0.13.2)

however in the mesages you posted I can often find something like : ....language//modinfo.php
Which looks like a langauge directory is missing or XOOPS is trying to fins a language with no name. Perhaps you should start your search in this area ?

Hope it helps a little.

kind regards Highlander

So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
www.AnimalPedigree.com

39

Re: Menu trouble XOOPS

2005/11/25 13:38
highlander
Not too shy to talk
Posts: 151
Since: 2004/12/5

Hi Fizzzot,

this issue has been raised before and you can read all about it in this thread.

greetings Highlander

So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
www.AnimalPedigree.com

40

Re: Synchronization - Website and local environment

2005/11/25 13:34
highlander
Not too shy to talk
Posts: 151
Since: 2004/12/5

Quote:

I downloaded all files and modified mainfile.php and restored the database file successfully (at least I hope so... )

Hi gerald, looks like there is a problem connecting to the database (as you state) and indedd your solution needs to lie somewhere in mainfile.php

please compare the settings of the mainfile.php which came with xsas (I believe XOOPS 2.0.6) to the new settings. (your new local mainfile is now 2.0.13.1 I believe)

Xsas also comes with phpmyadmin so you can check the database name and such.

Good luck, Highlander

So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
www.AnimalPedigree.com

Stats
Goal:	$100.00
Due Date:	Apr 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

Re: error help..

Re: DB Issue

Re: Anti-spam guestbook

Re: Server Crash

Re: Notification doesn't work at all

Re: How can I change the Web Links sorted by popularity initially?

mysql search for 'funny' characters

Re: Upgraded from 2.0.7.3 to 2.2.3

Re: Menu trouble XOOPS

Re: Synchronization - Website and local environment

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