Water in driver side floor

If this happens after you've run your AC and it's water, then you have a clogged condensate drain. The condensation can't drain out and fills the heater box until it overflows. See this post on clogged drains.
https://ricksfreeautorepairadvice.com/passenger-side-carpet-wet/

It depends, is it antifreeze or clear water? It could be condensation from the ac. Sometimes you can get under the vehicle and use a probe in the drain. It would probably be the best to clean out from inside, if that is the problem?

Since it was drilled-- verses-- making the proper fix in the past

Your ONLY option-- is completely remove as much as necessary,
until you have found ALL problems & butchered work & reassemble correctly & replace that drilled item

The condensation drain line has either gotten plugged or has fallen off.

The component of an A/C system that makes the air cold is called the evaporator, logically it needs to be in the air-conditioned space. In cars it's nearly always in the dashboard on the passenger side.

Warm air holds more moisture than cold air, so as air is circulated through the evaporator to cool it, the moisture in the air condenses back to liquid, like a mini rain shower in a box. That water, usually called condensate, has to go somewhere so there is a hole in the bottom of the evaporator and a tube to carry it out of the cab, through the firewall, into the engine compartment and onto the ground.

If the tube becomes plugged, condensate will accumulate until it overflows an air vent. If it comes off or cracks, the problem is obvious. It's pretty common for a condensate drain in a car to plug, junk falls into the intake vent that won't fit down the drain.

Clearing it would be simple if getting to it wasn't so involved, check your service manual for details.

HEATER CORE AND AC EVAPORATOR DRAIN TUBE STOPPED UP ALLOWING AC CONDENSATING WATER OR SWEAT TO RUN IN FLOOR BOARD.OR LEAKING HEATER CORE WILL CAUSE WATER OR ANTIFREEZE IN FLOOR BOARD.

The rear ac evaporator box is not draining very well,and it is blowing the condensation up threw the vents,most likely.The drain should be under the rear passengers side wheel well.

That sounds like the AC condensation drain tube/hose is plugged up.

The AC evaporator/core condensation drain tube is located on the passenger side of the fire-wall towards the bottom of the fire-wall, (it resembles a heater hose that is coming off from the fire-wall and it connects to nothing, and it is just to drain the AC condensation) and it is easily viewed from under the vehicle. Use long pipe cleaners folded in half to clean out the AC drain, and be very careful that the AC evaporator/core, or the heater core is not damaged from using any hard or sharp objects to clean out the AC drain.

The evaporator box drain is stopped up.Under hood,under the firewall,right below the ac lines,you will find the drain.Take a small wire,like balin wire and move it in and out of the drain hole to relieve the water,it will pour out pretty good.If this doesn`t work,try compressed air pressure.I hope this helps.

The AC evaporator units have a drain hose that runs through the floor because condensed moisture is a fact of life with AC units. Yours is plugged. You will have to get under the vehicle and look for the hose where it comes out, then take like coat hanger wire and clean it out, It is somewhere in the vicinity of where the passenger foot well meets the fire wall. If you have to raise the vehicle to get under it, make certain you have it safely supported. If you don't have the stuff, drive the passenger side wheels up on a good curb and use some cardboard to slide under.

I am the original owner of camry xle 1998 with wet floors. In 2000 I had drivers side door seal leaking at welt. Removed old door seal and new weather strip on drivers side installed. The door panel was never wet, but wet at bottom of door where there are drain holes...slowly leaking under carpet.
In 2001 later water again. Coming from overflowing A/C evaporator-drain plugged/ tank full of debris. Removed evaporator, cleaned + drain cleaned.
In 2003, driver door seal against window rotted. Removed door panel and found leak at window belt molding at the mirror joint inside + out. Lots of mold under carpet needed to replace! Made a fuss at dealers for reacurring problem and they replaced the carpet for free.