1
reflect
Re: wf-faq 1.0.5 not adding faq's to the db
  • 2005/3/7 15:32

  • reflect

  • Just popping in

  • Posts: 7

  • Since: 2004/9/15


Ok, I think I found it.

topicID was tinyint(4). I can't believe no one else has bumped into this limit before. I changed it in place to integer(8) so there would be a bit of room for the topics created.. seems to work now, atleast.



2
reflect
Re: wf-faq 1.0.5 not adding faq's to the db
  • 2005/3/7 15:07

  • reflect

  • Just popping in

  • Posts: 7

  • Since: 2004/9/15


ok, I removed one FAQ entry and then I could suddenly enter a new entry. I currently have 127 entries, adding no. 128 isn't possible.

I checked the database with mysqlcc and I checked the properties of the 'xoops_faqtopics' table and it says data_free 0, data_length 31472 and rows 127.

Is this a limit of wf-faq or something? I really need to raise that, alot. Or is this something that doesn't have anything to do with the problem at hand?



3
reflect
wf-faq 1.0.5 not adding faq's to the db
  • 2005/3/7 14:17

  • reflect

  • Just popping in

  • Posts: 7

  • Since: 2004/9/15


Installed wf-faq recently and added alot of entries to it. However, after adding something like 150 entries, it blurted out "faq NOT added" but it gives me no other message.

I've enabled the php debug but that doesn't give me any information. What can I do to make it give me more information about the problem at hand?

(besides enabling php debug, I tried MySQL debug and the other one in system/preferences. this is on a linux machine, so I've looked in mysqld.log and the syslog, and apache's error_log adn access_log but so far it hasn't given me anything to go on)

When a user submits a FAQ, they get "ERROR: Database has NOT been Updated due to an Error!" and when an admin does the same, they get the "faq NOT created and saved" error.



4
reflect
Re: all pages blank on install 2.0.7
  • 2004/9/23 9:40

  • reflect

  • Just popping in

  • Posts: 7

  • Since: 2004/9/15


grep extension= `locate php.ini`
extension=mysql.so

Check that you have that line in your php.ini.



5
reflect
Re: blank page during install
  • 2004/9/16 10:24

  • reflect

  • Just popping in

  • Posts: 7

  • Since: 2004/9/15


I've checked the privileges with 'mysqlcc' now and made sure the user I'm installing with has ALL rights, globally. But I still get the same, non-descript blank page.

Since the user has the rights to create a db, I tried putting a name of a db that didn't exist, and the installer doesn't complain, but still gets me a blank page.

What am I missing here?



6
reflect
Documentation enhancement
  • 2004/9/15 16:41

  • reflect

  • Just popping in

  • Posts: 7

  • Since: 2004/9/15


After reading the installation instructions, and then looking for more information, I found a 'xoops for dummies' that was sort of ok. What really bugs me about the installation instructions is 'create a database' when all there's needed is a handfull of cli commands to get it setup correctly.

mysql -uroot mysql
create..
grant..

It would be fairly easy and would be highly apreciated by people that are setting this up from scratch and NOT using a hosting company.



7
reflect
Re: blank page during install
  • 2004/9/15 16:21

  • reflect

  • Just popping in

  • Posts: 7

  • Since: 2004/9/15


I'm having this exact behaviour on 2 machines right now. I've searched the entire XOOPS site and there are no fixes for this one that I can see.

Here's what I've done:

downloaded and unpacked XOOPS 2.0.7.3, installed MySQL 3.23.58 and all the required packages. The system is a redhat machine, btw.

I follow the instructions, set permissions on dirs and the file and create a database and a user, using the GRANT option to give this user FULL rights for testing purposes. Start the installation, pick english (next), some text (next), all green lights for the permissions (next), put in all the info for the dbhost, dbuser, dbpass etc (next), confirm it (next), it saves the data, all green (next), confirm paths/URL all green (next), confirm database (next),
and I get a white page..
View source gives me this on mozilla:
<html><body></body></html>
and this using MSIE:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="test/html; charset=utf-8"></HEAD>
<BODY></BODY></HTML>

The other pages I've found on this site all seems to be discussing blank pages AFTER a successful install.

My friend had this exact problem a while ago and solved it, though he doesn't remember how. The fact that I get the exact same problem on 2 different machines (both OS and hardware) tells me that either I'm doing something completely fscked up, or, there's something wrong with the install script.

Oh, and I've tried using localhost, the hostname, the hostname with the FQDN and then a totally bogus name and it surprised me that the installer didn't barf at me there.

I've checked the logs. No errors in the apache logfiles, nothing in the MySQL logfiles.. nada. I don't know what to try next. Suggestions?




TopTop



Login

Who's Online

222 user(s) are online (148 user(s) are browsing Support Forums)


Members: 0


Guests: 222


more...

Donat-O-Meter

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

Latest GitHub Commits