1
tywick
Re: SQL error revealed by debug, please advise
  • 2004/3/10 20:58

  • tywick

  • Just popping in

  • Posts: 12

  • Since: 2002/9/17


Quote:
Debug reveals the following error:

SELECT * FROM xoops_session WHERE login_type='1' AND uid>0
Error number: 1054
Error message: Unknown column 'uid' in 'where clause'


change the SQL statement from this

SELECT FROM xoops_session WHERE login_type='1' AND uid>0


to this

SELECT FROM xoops_session WHERE login_type='1' AND member_id>0


see if that helps.

I'm not exactly sure what file the code is from. You may need to alter code that is trying to grab info from that statement.






2
tywick
Re: I would like to change the word Occupation in the member Profile
  • 2004/3/4 22:16

  • tywick

  • Just popping in

  • Posts: 12

  • Since: 2002/9/17


You would be better off altering the constant _MM_OCCUPATION

define("_MM_OCCUPATION","Profession contains");

Note: The actual code is looking for the constant _MM_OCCUPATION



3
tywick
Re: Help me, Problem with query DELETE FROM
  • 2003/12/29 8:41

  • tywick

  • Just popping in

  • Posts: 12

  • Since: 2002/9/17


It would probably work better if you actually did a mysql_query instead of sprintf. I'm sure there's other changes you'd need to do but that's a good place to start.



4
tywick
Re: What is the best review module? (if any)
  • 2003/12/18 11:53

  • tywick

  • Just popping in

  • Posts: 12

  • Since: 2002/9/17


If you're patient you can also wait for the release of T-Reviews. No date is yet set for when it will be complete but IMHO it will be the most flexable review module availble. For more info visithttp://dev.tywick.com/modules/newbb/index.php?cat=6

In brief it is capable of the following that the others are not:

Unlimited rating criteria
Different rating criteria for different categories
Use of sliders to retrieve input from users

And some others that I'm probably forgetting but those are the major ones.



5
tywick
Re: multiple instances of same module
  • 2003/10/20 20:11

  • tywick

  • Just popping in

  • Posts: 12

  • Since: 2002/9/17


Yes this is possible. Just make sure to make the following changes to one of the modules.

in xoops_version.php
$modversion['dirname'] -- whatever you decide to rename the directory as
$modversion['name'] -- whatever name you want to appear in the main menu
$modversion['tables'][n] -- change all table names ie module_info to module2_info

in mysql.sql

change all table names ie module_info to module2_info make sure these changes properly coordinate with $modversion['tables'][n] changes

in all other files properly change sql references and directory references



6
tywick
Re: Urgent! My main page missing! pls help
  • 2003/10/19 9:30

  • tywick

  • Just popping in

  • Posts: 12

  • Since: 2002/9/17


Re-upload index.php at the base XOOPS directory. If That doesn't work then manually check your DB in table "_config" where "conf_name" = "startpage" and check what it is set to. Otherwise I don't know what else to tell you.



7
tywick
Re: My God... ADMIN ICON IS GONE... HEEEEELP PLEASE !!! [SOLVED]
  • 2003/10/19 0:28

  • tywick

  • Just popping in

  • Posts: 12

  • Since: 2002/9/17


Coplan look here:

https://xoops.org/modules/newbb/viewtopic.php?topic_id=13000&forum=7&post_id=52185#forumpost52185

Hopefully my answer to AlexM will help you as well.



8
tywick
Re: I just lost part of my Administration Menu!
  • 2003/10/19 0:15

  • tywick

  • Just popping in

  • Posts: 12

  • Since: 2002/9/17


I had this problem as well when upgrading.

Quick easy painless fix:

In the address bar of your browser type {your-url}/modules/system/admin.php?fct=groups&op=modify&g_id=1
(I recommend C&P the above and insert your XOOPS URL -- http://www.zobot.net/modules/system/admin.php?fct=groups&op=modify&g_id=1 maybe?)

Now select every check box to give the Webmaster group access to every "System Admin rights"

Now click "Update Group" and voila! Everything should be back to normal now.



9
tywick
Re: Which forum module do you reckon?
  • 2003/10/18 19:30

  • tywick

  • Just popping in

  • Posts: 12

  • Since: 2002/9/17


Quote:

JackJ wrote:
Rayzor

<snip>

In fact he has an extra file which brings IPB into a 100% view bypassing blocks settings.

Koudanshi

<snip>


He didn't intend for "bypassing" the blocks as a feature. this is due to the template conflict as I mentioned in my previous post. If that's what you prefer then YaBB TDfX 2 works like a charm as well.



10
tywick
Re: Which forum module do you reckon?
  • 2003/10/18 19:20

  • tywick

  • Just popping in

  • Posts: 12

  • Since: 2002/9/17


Quote:

charpres wrote:
If I had a choice, I would use Yabbse. I read somewhere here that someone has or almost has a Yabb module.
<snip>


That would be YaBB TDfX, however, just like IPBM and phpBB2M there's a huge conflict with the XOOPS 2 template. The XOOPS 1.3 version works with out a hitch. Also YaBB TDfX installs much easier than IPBM or phpBB2M. One thing to keep in mind if no one else has mentioned in this thread is that newBB is built from phpBB2 so your hack for your phpBB2 board would be easy to implement into newBB.




TopTop
(1) 2 »



Login

Who's Online

186 user(s) are online (104 user(s) are browsing Support Forums)


Members: 0


Guests: 186


more...

Donat-O-Meter

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

Latest GitHub Commits