31
mvandam
Re: User is unable to view account
  • 2004/1/19 0:34

  • mvandam

  • Quite a regular

  • Posts: 253

  • Since: 2003/2/7 2





32
mvandam
Re: Did all that but still have problems
  • 2004/1/18 22:35

  • mvandam

  • Quite a regular

  • Posts: 253

  • Since: 2003/2/7 2


You should be able to edit the file "mainfile.php" directly to reflect your database connection settings. (However, you should use the installer at least once to create all the database tables and insert the initial configuration options. Unfortunately there is no ".sql" file you can run to do all of this from the command line - the configuration options would be missing.)



33
mvandam
Re: Did all that but still have problems
  • 2004/1/17 2:19

  • mvandam

  • Quite a regular

  • Posts: 253

  • Since: 2003/2/7 2


Quote:

We'll back to the problem. Yes I did the "/usr/local/mysql/bin/mysql -u root -p password -h `hostname` xxx" and it gave me the whole nine yards of help page tips. Tried it without the "xxx" (replaced with my real pw) at the end and the ended up with an error message: "ERROR 1102: Incorrect dabase name 'edquist.se-local'" wich happens to be the name of my host... not my database.

Sounds like the arguments are not getting read correctly.

/usr/local/mysql/bin/mysql -u <username> -p <optional_password> -h <hostname> <databasename>

'xxx' in the position you have it above is your desired *database* not the password. The password should go right after the "-p" (or omit it and you will be prompted for it -- safer!). You shouldn't be typing the string "password" anywhere. Also try NOT putting the backticks around the hostname... I think that is causing some problems too.

So for example:

/usr/local/mysql/bin/mysql -u root -p -h localhost xoops

where 'localhost' should be replaced with your database hostname, and 'xoops' should be replaced with your desired database to connect to. (Note you can leave out the database name and just type 'connect xoops' once you get into the MySQL shell.

Good luck



34
mvandam
Re: Did all that but still have problems
  • 2004/1/16 17:45

  • mvandam

  • Quite a regular

  • Posts: 253

  • Since: 2003/2/7 2


Add the "-p" argument and it should prompt you for a password.

i.e. /usr/local/mysql/bin/mysql -u root -p password -h `hostname` xxx

Note if you leave out 'password' (leave in "-p") which is a very GOOD idea by the way, then you will be prompted for the password after hitting 'enter'.



35
mvandam
Re: User is unable to view account
  • 2004/1/16 2:58

  • mvandam

  • Quite a regular

  • Posts: 253

  • Since: 2003/2/7 2


Hmmm, I have not observed this problem. Maybe a problem with the searching function of mantis? Any error messages displayed? (Might have to add an 'exit' somewhere in the code to break out of endless loop...)

Also make sure to apply the 'XOOPS_ROOT_PATH' fix described in the forums:

https://xoops.org/modules/newbb/viewto ... hp?topic_id=11603&forum=4



36
mvandam
Re: Mantis-Bugtracker: Errors non stop!
  • 2004/1/16 2:54

  • mvandam

  • Quite a regular

  • Posts: 253

  • Since: 2003/2/7 2


This has been previously discussed in the forums:

https://xoops.org/modules/newbb/viewto ... hp?topic_id=11603&forum=4

Whenever the next release happens, this fix will be incorporated.



37
mvandam
Re: BLank page after install, have error code, please look.....
  • 2004/1/9 3:53

  • mvandam

  • Quite a regular

  • Posts: 253

  • Since: 2003/2/7 2


'session_start' is a built-in php function. I'm not sure what that error means, perhaps your server configuration has a slight problem. Check these docs for some help (I just did a google search for your error message):

http://p2p.wrox.com/archive/pro_php/2001-08/37.asp
http://www.faqts.com/knowledge_base/view.phtml/aid/13108

good luck!



38
mvandam
Re: Preparing Text to go in and out of a Xoops DB
  • 2004/1/8 18:34

  • mvandam

  • Quite a regular

  • Posts: 253

  • Since: 2003/2/7 2


Yes, 'getVar' causes automatic sanitization (according to the options you selected with 'initVar'... i.e. things like bbcode, smilies, etc.) Have a look in kernel/object.php for more details.

For the multilingual stuff, you would have to call the function manually as you are doing now. To save yourself a lot of extra function calls, you could implement the multilang stuff as a 'markup option' (as bbcode, smilies, html, etc...) and change the appropriate calls to 'initVar' to add this option on multilingual fields. I'm not sure how well this would work... just a thought off the top of my head.



39
mvandam
Re: tplfile not updated when updating module
  • 2004/1/8 2:17

  • mvandam

  • Quite a regular

  • Posts: 253

  • Since: 2003/2/7 2


Did cloning the default template set work for you?

As for the reason cloning is needed... This is just a guess, but I suspect it was implemented just as a precaution so if someone messes up a template, they can always revert to the default template set and their site should still work properly. If you could edit the default templates directly, an error could make your site inaccessible.



40
mvandam
Re: Preparing Text to go in and out of a Xoops DB
  • 2004/1/8 2:13

  • mvandam

  • Quite a regular

  • Posts: 253

  • Since: 2003/2/7 2


I believe that (some of) these functions are still used internally, but not intended to be part of the API used by developers.

Anyone please correct me if I'm wrong, but as far as I know, all the sanitization is done in class methods 'getVar' and 'setVar' of classes derived from XoopsObject.

- setVar(key,value) sets the value of a 'field'. It will automatically be sanitized before insert into the database.

- getVar(key,format) converts based on the 'type' of the variable and the selected 'format'. The values of 'format' can be:

(1) 's' for 'show' (use when displaying on a page)
(2) 'e' for 'edit' (use when you show in an edit box)
(3) 'p' for 'preview' (unsure of purpose)
(4) 'f' for 'formpreview' (unsure of purpose)
(5) 'n' for 'none' (use when you want the value exactly as inserted)

The options of whether you want to render smilies, html etc, is established when you call 'initVar' to initialize each var in your class (derived from XoopsObject). Have a look at e.g. kernel/user.php or kernel/module.php etc for some examples of class derived from XoopsObject. If all your data is handled by a XoopsObject then you just use 'setVar', 'getVar', and sanitization automagically happens when you insert into or retrieve from the database.

Hope this helps a bit...




TopTop
« 1 2 3 (4) 5 6 7 ... 21 »



Login

Who's Online

57 user(s) are online (32 user(s) are browsing Support Forums)


Members: 0


Guests: 57


more...

Donat-O-Meter

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

Latest GitHub Commits